{"id":2804,"date":"2023-07-20T15:17:35","date_gmt":"2023-07-20T15:17:35","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/"},"modified":"2023-07-20T15:17:35","modified_gmt":"2023-07-20T15:17:35","slug":"excel-abaikan-div-0","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/","title":{"rendered":"Bagaimana cara mengabaikan #div\/0! saat menggunakan pembagian di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Di Excel, jika Anda mencoba membagi nilai dengan nol, Anda akan menerima <strong>#DIV\/0!<\/strong> Karena itu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk melakukan pembagian dengan mengabaikan <strong>#DIV\/0!<\/strong> nilai:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR( <span style=\"color: #3366ff;\">A2<\/span> \/ <span style=\"color: #ff0000;\">B2<\/span> , \"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam rumus khusus ini, kami mencoba membagi nilai sel <strong>A2<\/strong> dengan nilai sel <strong>B2<\/strong> . Jika <strong>B2<\/strong> ternyata nol, kita cukup mengembalikan kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Abaikan #DIV\/0 saat menggunakan pembagian di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mencoba membagi nilai di kolom A dengan nilai di kolom B pada spreadsheet Excel khusus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24626 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/div1.jpg\" alt=\"\" width=\"473\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa untuk setiap sel di kolom C di mana kita mencoba membaginya dengan nol, kita menerima <strong>#DIV\/0!<\/strong> Karena itu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengabaikan kesalahan ini, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR( <span style=\"color: #3366ff;\">A2<\/span> \/ <span style=\"color: #ff0000;\">B2<\/span> , \"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24627 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/div2.jpg\" alt=\"\" width=\"477\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang untuk setiap sel di kolom C tempat kita mencoba membaginya dengan nol, kita hanya menerima nilai kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga bisa menggunakan rumus berikut untuk mengembalikan angka nol sebagai hasilnya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR( <span style=\"color: #3366ff;\">A2<\/span> \/ <span style=\"color: #ff0000;\">B2<\/span> , 0)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24628 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/div3.jpg\" alt=\"\" width=\"463\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang untuk setiap sel di kolom C tempat kita mencoba membagi dengan nol, kita hanya menerima nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Atau kita bahkan dapat mengembalikan pesan khusus ketika kita mencoba membagi dengan nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR( <span style=\"color: #3366ff;\">A2<\/span> \/ <span style=\"color: #ff0000;\">B2<\/span> , \"Tried to divide by zero\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24629 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/div4.jpg\" alt=\"\" width=\"574\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang, untuk setiap sel di kolom C tempat kita mencoba membagi dengan nol, kita cukup menerima &#8220;Mencoba membagi dengan nol.&#8221;<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-abaikan-saja\/\" target=\"_blank\" rel=\"noopener\">Cara mengabaikan nilai #N\/A saat menggunakan rumus di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-ganti-na\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai #N\/A di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/outlier-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Mudah Menemukan Pencilan di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Di Excel, jika Anda mencoba membagi nilai dengan nol, Anda akan menerima #DIV\/0! Karena itu. Anda dapat menggunakan sintaks dasar berikut untuk melakukan pembagian dengan mengabaikan #DIV\/0! nilai: =IFERROR( A2 \/ B2 , &#8220;&#8221;) Dalam rumus khusus ini, kami mencoba membagi nilai sel A2 dengan nilai sel B2 . Jika B2 ternyata nol, kita cukup [&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>Bagaimana cara mengabaikan #DIV\/0! Saat menggunakan pembagian di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan saat melakukan pembagian di excel, sertakan beberapa contohnya.\" \/>\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-abaikan-div-0\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengabaikan #DIV\/0! Saat menggunakan pembagian di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan saat melakukan pembagian di excel, sertakan beberapa contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T15:17:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/div1.jpg\" \/>\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-abaikan-div-0\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/\",\"name\":\"Bagaimana cara mengabaikan #DIV\/0! Saat menggunakan pembagian di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T15:17:35+00:00\",\"dateModified\":\"2023-07-20T15:17:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan saat melakukan pembagian di excel, sertakan beberapa contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengabaikan #div\/0! saat menggunakan pembagian di excel\"}]},{\"@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":"Bagaimana cara mengabaikan #DIV\/0! Saat menggunakan pembagian di Excel - Statorials","description":"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan saat melakukan pembagian di excel, sertakan beberapa contohnya.","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-abaikan-div-0\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengabaikan #DIV\/0! Saat menggunakan pembagian di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan saat melakukan pembagian di excel, sertakan beberapa contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/","og_site_name":"Statorials","article_published_time":"2023-07-20T15:17:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/div1.jpg"}],"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-abaikan-div-0\/","url":"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/","name":"Bagaimana cara mengabaikan #DIV\/0! Saat menggunakan pembagian di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T15:17:35+00:00","dateModified":"2023-07-20T15:17:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan saat melakukan pembagian di excel, sertakan beberapa contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-abaikan-div-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-abaikan-div-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengabaikan #div\/0! saat menggunakan pembagian di excel"}]},{"@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\/2804"}],"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=2804"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2804\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}