{"id":2200,"date":"2023-09-25T06:33:35","date_gmt":"2023-09-25T06:33:35","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tong\/"},"modified":"2023-12-06T06:17:52","modified_gmt":"2023-12-06T06:17:52","slug":"tong","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tong\/","title":{"rendered":"Bagaimana cara menghitung ppn di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1962894150\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk menghitung PPN di Excel, Anda perlu mengetahui persentase pajak pastinya lalu mengalikannya dengan jumlah kotor untuk mendapatkan jumlah PPN. Setelah itu, tambahkan jumlah pajak ini ke jumlah faktur sebenarnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82435\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung-PPN\" width=\"579\" height=\"314\"><\/figure><\/div><p> Pada tutorial ini, kami menulis rumus untuk menghitung PPN. Mari kita periksa ini.<\/p><h2 class=\"wp-block-heading\"> Hitung PPN secara terpisah<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama, lihat sel dengan jumlah faktur.<\/li><li> Setelah itu masukkan operator asterisk (*) untuk perkalian.<\/li><li> Sekarang lihat sel tempat Anda memiliki persentase PPN.<\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan jumlah pajak. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82436\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-calculer-la-TVA-separement.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung-tong-secara terpisah\" width=\"589\" height=\"260\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=tax_percentage * invoice_amount<\/code><\/pre><p> Setelah Anda menekan enter, Anda akan mendapatkan jumlah PPN di sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82437\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-montant-de-TVA-obtenu.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-pung-hasil\" width=\"527\" height=\"286\"><\/figure><\/div><p> Pada bagian selanjutnya, Anda perlu menambahkan pajak ke jumlah total. Untuk melakukan ini, Anda harus merujuk ke sel dengan jumlah faktur kotor, masukkan operator tambahan dan merujuk ke sel dengan jumlah PPN (PAJAK) yang Anda hitung. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82438\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ajouter-la-taxe-au-montant.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan pajak ke jumlah\" width=\"600\" height=\"236\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=vat_amount + invoice_amount<\/code><\/pre><p> Ini akan memberi Anda jumlah total, termasuk jumlah PPN. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82439\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-montant-total-TTC.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-total-tong-tong\" width=\"556\" height=\"265\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Perhitungan PPN dalam jumlah total<\/h2><p> Jika Anda ingin jumlah PPN dimasukkan ke dalam jumlah total, Anda dapat menggunakan rumus di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82440\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-calculer-la-TVA-en-montant-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung-PPN-dalam-jumlah-total\" width=\"549\" height=\"244\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=(tax_percentage * invoice_amount) + invoice_amount<\/code><\/pre><p> Dengan rumus di atas, Anda tidak memerlukan kolom tersendiri untuk besaran PPN. Jumlah total termasuk jumlah pajak dan faktur.<\/p><p> Ada cara lain untuk menulis rumus ini. Dalam rumus ini Anda dapat menggunakan persentase untuk mendapatkan jumlah total termasuk PPN. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=invoice_amount * (100% + vat_percentage)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82441\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-autres-formules-pour-calculer-la-TVA-au-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-lain-untuk-menghitung-total-PPN\" width=\"512\" height=\"280\"><\/figure><\/div><p> Rumus ini berfungsi seperti rumus pertama, namun kami menggunakan persentase.<\/p><p> Jika menggunakan 100% dan menambahkan persentase pajak, misalnya 10%, kalikan dengan jumlah invoice. Ini meningkatkan jumlah dengan persentase pajak yang tepat, dan Anda mendapatkan jumlah total termasuk pajak. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-la-TVA.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/\">Hitung bunga majemuk di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bunga-sederhana\/\">Hitung Bunga Sederhana di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/margin-keuntungan\/\">Laba kotor (margin dan rasio)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2200","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menghitung PPN di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung PPN suatu jumlah di Excel. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/tong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menghitung PPN di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung PPN suatu jumlah di Excel. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tong\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tong\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tong\/\",\"name\":\"\u25b7 Bagaimana cara menghitung PPN di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tong\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tong\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png\",\"datePublished\":\"2023-09-25T06:33:35+00:00\",\"dateModified\":\"2023-12-06T06:17:52+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung PPN suatu jumlah di Excel. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tong\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tong\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung ppn di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menghitung PPN di Excel? (Tutorial 2023)","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung PPN suatu jumlah di Excel. Mari kita periksa ini\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/tong\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghitung PPN di Excel? (Tutorial 2023)","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung PPN suatu jumlah di Excel. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/tong\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/tong\/","url":"https:\/\/exceladvisor.org\/id\/tong\/","name":"\u25b7 Bagaimana cara menghitung PPN di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tong\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tong\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png","datePublished":"2023-09-25T06:33:35+00:00","dateModified":"2023-12-06T06:17:52+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung PPN suatu jumlah di Excel. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tong\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tong\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-TVA.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung ppn di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2200"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2200\/revisions"}],"predecessor-version":[{"id":2654,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2200\/revisions\/2654"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}