{"id":5068,"date":"2023-07-04T06:13:43","date_gmt":"2023-07-04T06:13:43","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/"},"modified":"2023-07-04T06:13:43","modified_gmt":"2023-07-04T06:13:43","slug":"excel-perhitungan-pajak-terbalik","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/","title":{"rendered":"Perhitungan pajak terbalik di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat melakukan penghitungan pajak terbalik untuk mengetahui harga suatu barang sebelum pajak ditambahkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk melakukan ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Harga sebelum pajak = Harga setelah pajak \/ (1 + tarif pajak)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, harga suatu barang setelah pajak adalah <strong>$14<\/strong> dan Anda mengetahui tarif pajaknya adalah <strong>7%<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghitung harga suatu barang sebelum menambahkan pajak:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Harga sebelum pajak = $14 \/ (1 +7%)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Harga sebelum pajak = $14 \/ 1,07<\/span><\/li>\n<li> <span style=\"color: #000000;\">Harga sebelum pajak = $13,08<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Harga item ini sebelum pajak ditambahkan adalah <strong>$13,08<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan rumus ini untuk melakukan penghitungan pajak terbalik di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Perhitungan pajak terbalik di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar produk berikut di Excel dengan harga yang sudah ditambah pajak:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39502 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revtax1.png\" alt=\"\" width=\"504\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita mengetahui tarif pajak untuk setiap barang adalah 7% dan kita ingin mengetahui harga asli setiap produk sebelum pajak ditambahkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tarif pajak ini bisa kita tentukan di sel <strong>F1<\/strong> , lalu ketikkan rumus berikut di sel <strong>C2<\/strong> untuk mencari harga asli produk pertama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #3366ff;\">B2<\/span> \/(1+ <span style=\"color: #ff0000;\">$F$1<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39503\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revtax2.png\" alt=\"Perhitungan tarif pajak terbalik di Excel\" width=\"577\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C sekarang menunjukkan harga setiap produk sebelum ditambah pajak 7%.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Produk seharga $14 dengan tarif pajak 7% berharga <strong>$13,08<\/strong> sebelum pajak ditambahkan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Produk seharga $18 dengan tarif pajak 7% berharga <strong>$16,82<\/strong> sebelum pajak ditambahkan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Produk seharga $20 dengan tarif pajak 7% berharga <strong>$18,69<\/strong> sebelum pajak ditambahkan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10% nilai teratas di kolom Excel<\/a><br \/> Cara Menghitung Persentase Kumulatif di Excel<br \/> <a href=\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan persentase di excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat melakukan penghitungan pajak terbalik untuk mengetahui harga suatu barang sebelum pajak ditambahkan. Anda dapat menggunakan rumus berikut untuk melakukan ini: Harga sebelum pajak = Harga setelah pajak \/ (1 + tarif pajak) Misalnya, harga suatu barang setelah pajak adalah $14 dan Anda mengetahui tarif pajaknya adalah 7% . Anda dapat menggunakan rumus berikut [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Perhitungan pajak terbalik di Excel (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan perhitungan pajak terbalik di Excel, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Perhitungan pajak terbalik di Excel (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan perhitungan pajak terbalik di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T06:13:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revtax1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/\",\"name\":\"Perhitungan pajak terbalik di Excel (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T06:13:43+00:00\",\"dateModified\":\"2023-07-04T06:13:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan perhitungan pajak terbalik di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Perhitungan pajak terbalik di excel (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Perhitungan pajak terbalik di Excel (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara melakukan perhitungan pajak terbalik di Excel, dengan sebuah contoh.","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:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/","og_locale":"id_ID","og_type":"article","og_title":"Perhitungan pajak terbalik di Excel (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan perhitungan pajak terbalik di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/","og_site_name":"Statorials","article_published_time":"2023-07-04T06:13:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revtax1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/","url":"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/","name":"Perhitungan pajak terbalik di Excel (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T06:13:43+00:00","dateModified":"2023-07-04T06:13:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan perhitungan pajak terbalik di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-perhitungan-pajak-terbalik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Perhitungan pajak terbalik di excel (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5068"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=5068"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5068\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}