{"id":1730,"date":"2023-11-08T21:51:25","date_gmt":"2023-11-08T21:51:25","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/"},"modified":"2023-12-06T06:14:44","modified_gmt":"2023-12-06T06:14:44","slug":"kesalahan-pembagian","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/","title":{"rendered":"Bagaimana cara memperbaiki kesalahan #div\/0 di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2140990476\"><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>Di Excel, #DIV\/0! Kesalahan terjadi saat Anda mencoba membagi angka dengan nol atau Anda memiliki nilai yang setara dengan nol, yang mungkin merupakan nilai kosong. Inilah mengapa Anda mendapatkan tanda #DVI\/0! yang menunjukkan bahwa Anda mencoba membagi suatu nilai dengan nol.<\/p><p> Dalam contoh berikut, Anda melihat kami memiliki nilai numerik di sel A1, dan kemudian kami memiliki nilai nol di sel B1. Sekarang ketika Anda memasukkan rumus di sel C1. Anda mendapatkan kesalahan ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70613\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"sel yang terbagi\" width=\"413\" height=\"307\"><\/figure><\/div><h2 id=\"h-div-0-with-a-blank-cell\" class=\"wp-block-heading\"> #DIV\/0! Dengan sel kosong<\/h2><p> Selain itu, jika Anda menggunakan referensi sel pada rumusnya dan salah satu selnya sudah memiliki #DIV\/0! Anda akan mendapatkan kesalahan ini lagi pada hasilnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70614\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/erreur-2-div0.png\" sizes=\"auto, \" srcset=\"\" alt=\"#div0-kesalahan\" width=\"402\" height=\"319\"><\/figure><\/div><h2 id=\"h-div-0-error-with-an-average\" class=\"wp-block-heading\"> #DIV\/0! Kesalahan dengan rata-rata<\/h2><p> Jika Anda menggunakan fungsi rata-rata untuk menghitung rata-rata nilai numerik dan salah satu nilai tersebut adalah #DIV\/0! Error, Anda akan mendapatkan error lagi pada hasilnya. Bahkan dengan fungsi rata-rata lainnya seperti AVERAGEA, AVERAGEIF dan AVERAGEIFS Anda akan menghadapi masalah yang sama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70615\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/erreur-3-div0-avec-moyenne.png\" sizes=\"auto, \" srcset=\"\" alt=\"#div0-kesalahan-dengan-rata-rata\" width=\"401\" height=\"366\"><\/figure><\/div><h2 id=\"h-how-to-fix-div-0-divide-by-zero-error\" class=\"wp-block-heading\"> Bagaimana cara memperbaiki #DIV\/0! (Dibagi dengan nol) Kesalahan<\/h2><p> Cara terbaik untuk memperbaiki kesalahan ini adalah dengan menggabungkan rumus asli dengan fungsi IFERROR untuk membuat kondisi jika terjadi kesalahan.<\/p><ol type=\"1\"><li> Pertama, jika semua, masukkan IFERROR di sel C1 dan masukkan tanda kurung di depannya.<\/li><li> Setelah itu pada argumen nilai gunakan rumus pembagian.<\/li><li> Sekarang masukkan koma dan di value_if_error masukkan nilai yang ingin Anda dapatkan jika #DIV\/0! Kesalahan atau kesalahan lainnya.<\/li><li> Terakhir, tambahkan tanda kurung tutup dan tekan Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70616\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-corriger-lerreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"memperbaiki kesalahannya\" width=\"537\" height=\"280\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IFERROR(A1\/B1,\"There's an Error\")<\/code><\/pre><p> Ini adalah salah satu solusi untuk memastikan Anda mendapatkan hasil yang lebih mudah dibaca saat mencoba membagi angka dengan nol (#DIV\/0!).<\/p><h2 id=\"h-using-if-to-fix-div-0-error\" class=\"wp-block-heading\"> Gunakan IF untuk mengoreksi #DIV\/0! Kesalahan<\/h2><p> Namun selain itu Anda juga bisa menggunakan kondisi IF untuk membuat tes jika ada kesalahan dan kemudian mengganti nilai kesalahan tersebut dengan yang lain. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70617\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-utiliser-if-pour-corriger-lerreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-jika-untuk-memperbaiki-kesalahan\" width=\"598\" height=\"244\"><\/figure><\/div><p> Pada contoh di atas, kita menggunakan fungsi IF dan ISERROR untuk membuat kondisi. Pada rumusnya, pertama kita menggunakan fungsi IF, dan pada argumen pertama IF kita menggunakan ISERROR untuk menguji apakah ada kesalahan dalam perhitungan.<\/p><p> Dan jika ada error maka akan mengembalikan nilai yang kita tentukan dan jika tidak ada error maka akan membagi lagi nilai A1 dengan nilai sel B1. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309 gb-grid-wrapper-download-2\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text\"> Dapatkan file Excelnya <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-509e8e50 gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/erreur-div0.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><\/div><\/div><\/div><\/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\/kesalahan-tumpahan\/\">#MENYEBAR! Kesalahan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/\">#VALUE Kesalahan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengabaikan-kesalahan\/\">Abaikan semua kesalahan di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/\">#N\/A Kesalahan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-referensi\/\">#REF! Kesalahan di Excel<\/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-1730","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>Bagaimana cara memperbaiki kesalahan #DIV\/0 di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara memperbaiki kesalahan #DIV\/0 di Excel secara detail menggunakan metode yang mudah diikuti.\" \/>\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\/kesalahan-pembagian\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memperbaiki kesalahan #DIV\/0 di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara memperbaiki kesalahan #DIV\/0 di Excel secara detail menggunakan metode yang mudah diikuti.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/\",\"name\":\"Bagaimana cara memperbaiki kesalahan #DIV\/0 di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png\",\"datePublished\":\"2023-11-08T21:51:25+00:00\",\"dateModified\":\"2023-12-06T06:14:44+00:00\",\"description\":\"Dalam tutorial rumus ini, kita akan mempelajari cara memperbaiki kesalahan #DIV\/0 di Excel secara detail menggunakan metode yang mudah diikuti.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memperbaiki kesalahan #div\/0 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":"Bagaimana cara memperbaiki kesalahan #DIV\/0 di Excel? (Tutorial 2023)","description":"Dalam tutorial rumus ini, kita akan mempelajari cara memperbaiki kesalahan #DIV\/0 di Excel secara detail menggunakan metode yang mudah diikuti.","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\/kesalahan-pembagian\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memperbaiki kesalahan #DIV\/0 di Excel? (Tutorial 2023)","og_description":"Dalam tutorial rumus ini, kita akan mempelajari cara memperbaiki kesalahan #DIV\/0 di Excel secara detail menggunakan metode yang mudah diikuti.","og_url":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/","url":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/","name":"Bagaimana cara memperbaiki kesalahan #DIV\/0 di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png","datePublished":"2023-11-08T21:51:25+00:00","dateModified":"2023-12-06T06:14:44+00:00","description":"Dalam tutorial rumus ini, kita akan mempelajari cara memperbaiki kesalahan #DIV\/0 di Excel secara detail menggunakan metode yang mudah diikuti.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-diviser-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memperbaiki kesalahan #div\/0 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\/1730","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=1730"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1730\/revisions"}],"predecessor-version":[{"id":2368,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1730\/revisions\/2368"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}