{"id":4607,"date":"2023-07-09T16:47:28","date_gmt":"2023-07-09T16:47:28","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/"},"modified":"2023-07-09T16:47:28","modified_gmt":"2023-07-09T16:47:28","slug":"google-sheet-abaikan-div-0","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/","title":{"rendered":"Google spreadsheet: cara mengabaikan #div\/0! kesalahan"},"content":{"rendered":"

<\/p>\n

\n

Di Google Spreadsheet, jika Anda mencoba membagi nilai dengan nol, Anda akan menerima #DIV\/0!<\/strong> Karena itu.<\/span><\/p>\n

Anda dapat menggunakan sintaks dasar berikut untuk melakukan pembagian dengan mengabaikan #DIV\/0!<\/strong> nilai:<\/span><\/p>\n

 =IFERROR( A2<\/span> \/ B2<\/span> , \"\")\n<\/strong><\/pre>\n
 Dalam rumus khusus ini, kami mencoba membagi nilai sel A2<\/strong> dengan nilai sel B2<\/strong> .<\/span><\/p>\n
 Jika B2<\/strong> ternyata nol, kita cukup mengembalikan kosong.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Abaikan #DIV\/0 saat menggunakan pembagian di Google Sheets<\/strong><\/span><\/h2>\n
 Katakanlah kita mencoba membagi nilai di kolom A dengan nilai di kolom B pada spreadsheet Google Sheets khusus ini:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa untuk setiap sel di kolom C di mana kita mencoba membaginya dengan nol, kita menerima #DIV\/0!<\/strong> Karena itu.<\/span><\/p>\n
 Untuk mengabaikan kesalahan ini, kita bisa mengetikkan rumus berikut di sel C2<\/strong> :<\/span><\/p>\n
 =IFERROR( A2<\/span> \/ B2<\/span> , \"\")<\/strong><\/pre>\n
 Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n
\"Google<\/p>\n
 Sekarang untuk setiap sel di kolom C tempat kita mencoba membaginya dengan nol, kita hanya menerima nilai kosong.<\/span><\/p>\n
 Perhatikan bahwa kita juga bisa menggunakan rumus berikut untuk mengembalikan angka nol sebagai hasilnya:<\/span><\/p>\n
 =IFERROR( A2<\/span> \/ B2<\/span> , 0<\/span> )<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang untuk setiap sel di kolom C tempat kita mencoba membagi dengan nol, kita hanya menerima nol.<\/span><\/p>\n
 Catatan<\/strong> : Silakan ganti nol dengan nilai numerik atau teks apa pun yang ingin Anda tampilkan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Sheets: cara mengurutkan dan mengabaikan spasi kosong<\/a>
 Google Sheets: Cara Mengabaikan Sel Kosong dengan Rumus<\/a>
 Google Spreadsheet: Cara mengabaikan nilai #N\/A<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Di Google Spreadsheet, 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 , “”) Dalam rumus khusus ini, kami mencoba membagi nilai sel A2 dengan nilai sel B2 . Jika B2 ternyata nol, kita […]<\/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":"\nGoogle Spreadsheet: Cara mengabaikan #DIV\/0! Kesalahan - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan di Google Sheets, dengan beberapa 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\/google-sheet-abaikan-div-0\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengabaikan #DIV\/0! Kesalahan - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T16:47:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sig1.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\/google-sheet-abaikan-div-0\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/\",\"name\":\"Google Spreadsheet: Cara mengabaikan #DIV\/0! Kesalahan - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T16:47:28+00:00\",\"dateModified\":\"2023-07-09T16:47:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara mengabaikan #div\/0! kesalahan\"}]},{\"@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":"Google Spreadsheet: Cara mengabaikan #DIV\/0! Kesalahan - Statorial","description":"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan di Google Sheets, dengan beberapa 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\/google-sheet-abaikan-div-0\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengabaikan #DIV\/0! Kesalahan - Statorial","og_description":"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/","og_site_name":"Statorials","article_published_time":"2023-07-09T16:47:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sig1.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\/google-sheet-abaikan-div-0\/","url":"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/","name":"Google Spreadsheet: Cara mengabaikan #DIV\/0! Kesalahan - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T16:47:28+00:00","dateModified":"2023-07-09T16:47:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan kesalahan #DIV\/0! kesalahan di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-abaikan-div-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara mengabaikan #div\/0! kesalahan"}]},{"@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\/4607"}],"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=4607"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4607\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}