{"id":2045,"date":"2023-10-23T03:12:53","date_gmt":"2023-10-23T03:12:53","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/"},"modified":"2023-12-06T06:14:28","modified_gmt":"2023-12-06T06:14:28","slug":"jika-nol-maka-kosong","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/","title":{"rendered":"Bagaimana cara memeriksa if 0 (nol) lalu kosong di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-244386518\"><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, jika Anda ingin memeriksa sel apakah nilai di dalamnya adalah 0 (nol) dan Anda ingin rumus mengembalikan hasil kosong, Anda bisa menggunakan fungsi IF untuk itu. Di IF Anda perlu menentukan sel dari mana Anda ingin memeriksa 0 dan kemudian menentukan nilai kosong yang ingin Anda dapatkan dalam hasil setelah kondisinya TRUE.<\/p><p> Dalam contoh berikut, kita memiliki daftar angka di kolom A dan sekarang Anda perlu menulis sebuah kondisi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"daftar angka\" width=\"342\" height=\"487\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus untuk mengecek IF 0 (nol) lalu kosongkan<\/h2><ol type=\"1\"><li> Pertama, di sel B2, masukkan fungsi IF.<\/li><li> Setelah itu, pada argumen pertama, tentukan kondisi untuk memeriksa nilai sel A2 (A2=0).<\/li><li> Sekarang di argumen kedua tentukan nol.<\/li><li> Dan di argumen ketiga, lihat sel A2.<\/li><li> Terakhir, masukkan tanda kurung penutup. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69516\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-si-formule-pour-trouver-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-rumus-untuk-menemukan-nol\" width=\"365\" height=\"480\"><\/figure><\/div><p> Berikut adalah rumus yang harus Anda gunakan untuk memeriksa apakah suatu sel memiliki nilai nol dan mengubahnya menjadi nol.<\/p><pre class=\"wp-block-preformatted\"> =IF(A2=0,\"\",A2)<\/pre><p> Sekarang mari kita coba memahami cara kerja rumus ini. Rumus ini bekerja dalam tiga bagian, di bagian pertama di mana kita memiliki kondisi yang memeriksa apakah sel tersebut memiliki nilai atau tidak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69517\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-si-formule-avec-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-rumus-dengan-salah\" width=\"488\" height=\"223\"><\/figure><\/div><p> Sekarang dua bagian berikutnya bersifat opsional dan berfungsi tergantung pada hasil kondisi.<\/p><p> Jika kondisinya TRUE (artinya nilai selnya 0) maka akan mendapat nilai kosong, dan jika kondisinya FALSE maka Anda akan mendapat nilai dari sel aslinya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69518\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-parties-facultatives-de-la-formule-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"opsional-bagian-of-jika-rumus\" width=\"459\" height=\"102\"><\/figure><\/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\/periksa-apakah-ada-nilai-dalam-suatu-rentang\/\">Periksa apakah ada nilai dalam rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\">Gabungkan fungsi IF dan AND di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\">Gabungkan fungsi IF dan OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\">IF Cell kosong (kosong) menggunakan IF + ISBLANK di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\">JIKA negatif maka nol (0) 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-2045","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 memeriksa IF 0 (nol) lalu kosong di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan memeriksa apakah ada 0 (nol) di sel dan kemudian mengembalikan kosong pada hasil rumus.\" \/>\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\/jika-nol-maka-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memeriksa IF 0 (nol) lalu kosong di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan memeriksa apakah ada 0 (nol) di sel dan kemudian mengembalikan kosong pada hasil rumus.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.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\/jika-nol-maka-kosong\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\",\"name\":\"Bagaimana cara memeriksa IF 0 (nol) lalu kosong di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.png\",\"datePublished\":\"2023-10-23T03:12:53+00:00\",\"dateModified\":\"2023-12-06T06:14:28+00:00\",\"description\":\"Dalam tutorial ini, kita akan memeriksa apakah ada 0 (nol) di sel dan kemudian mengembalikan kosong pada hasil rumus.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa if 0 (nol) lalu kosong 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 memeriksa IF 0 (nol) lalu kosong di Excel?","description":"Dalam tutorial ini, kita akan memeriksa apakah ada 0 (nol) di sel dan kemudian mengembalikan kosong pada hasil rumus.","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\/jika-nol-maka-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memeriksa IF 0 (nol) lalu kosong di Excel?","og_description":"Dalam tutorial ini, kita akan memeriksa apakah ada 0 (nol) di sel dan kemudian mengembalikan kosong pada hasil rumus.","og_url":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.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\/jika-nol-maka-kosong\/","url":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/","name":"Bagaimana cara memeriksa IF 0 (nol) lalu kosong di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.png","datePublished":"2023-10-23T03:12:53+00:00","dateModified":"2023-12-06T06:14:28+00:00","description":"Dalam tutorial ini, kita akan memeriksa apakah ada 0 (nol) di sel dan kemudian mengembalikan kosong pada hasil rumus.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-numeros-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa if 0 (nol) lalu kosong 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\/2045","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=2045"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2045\/revisions"}],"predecessor-version":[{"id":2351,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2045\/revisions\/2351"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}