{"id":1628,"date":"2023-11-15T02:07:04","date_gmt":"2023-11-15T02:07:04","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/"},"modified":"2023-12-06T06:14:21","modified_gmt":"2023-12-06T06:14:21","slug":"jika-selnya-kosong","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/","title":{"rendered":"Bagaimana cara memeriksa apakah sel kosong di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3380737388\"><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 apakah suatu sel kosong atau tidak, Anda bisa menggunakan rumus gabungan IF dan ISBLANK. Kedua rumus ini bekerja sedemikian rupa sehingga ISBLANK memeriksa nilai sel dan kemudian IF mengembalikan pesan lengkap yang bermakna (yang Anda tentukan) sebagai imbalannya.<\/p><p> Dalam contoh berikut, Anda memiliki daftar angka yang memiliki beberapa sel kosong. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69839\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"daftar-dengan-beberapa-sel kosong\" width=\"313\" height=\"357\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus untuk memeriksa apakah suatu sel kosong atau tidak (kosong)<\/h2><ol type=\"1\"><li> Pertama, di sel B1, masukkan IF di sel tersebut.<\/li><li> Sekarang di argumen pertama masukkan ISBLANK dan lihat sel A1 dan masukkan tanda kurung penutup.<\/li><li> Kemudian, pada argumen kedua, gunakan nilai &#8220;Kosong&#8221;.<\/li><li> Setelah itu pada argumen ketiga gunakan \u201cNon-Blank\u201d.<\/li><li> Terakhir, tutup fungsinya, tekan Enter dan seret rumus ke nilai terakhir yang Anda miliki dalam daftar. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69840\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-si-formule-pour-trouver-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-rumus-untuk-menemukan-kosong\" width=\"545\" height=\"385\"><\/figure><\/div><p> Seperti yang Anda lihat, kami memiliki nilai &#8220;Kosong&#8221; untuk sel yang selnya kosong di kolom A.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(ISBLANK(A1),\"Blank\",\"Non-Blank\")<\/code><\/pre><p> Sekarang mari kita pahami rumus ini. Pada bagian pertama kita memiliki ISBLANK yang memeriksa apakah sel kosong atau tidak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69841\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-est-la-fonction-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi kosong\" width=\"532\" height=\"395\"><\/figure><\/div><p> Dan setelah itu, jika nilai yang dikembalikan oleh ISBLANK adalah TRUE, maka IF akan mengembalikan \u201cBlank\u201d, dan jika nilai yang dikembalikan oleh ISBLANK adalah FALSE, IF akan mengembalikan \u201cNon_Blank\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69842\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-est-une-valeur-de-resultat-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"isblank-nilai-hasil\" width=\"509\" height=\"358\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus alternatif<\/h2><p> Anda juga bisa menggunakan rumus lain dimana Anda hanya perlu menggunakan fungsi IF saja.<\/p><p> Sekarang dalam fungsi tersebut Anda hanya perlu menentukan sel tempat Anda ingin menguji kondisinya dan kemudian menggunakan operator sama dengan dengan nilai kosong untuk membuat kondisi yang akan diuji.<\/p><p> Dan Anda hanya perlu menentukan dua nilai yang ingin Anda dapatkan kondisinya TRUE atau FALSE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69843\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-si-formule-avec-blanc-et-non-blanc.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-rumus-dengan-kosong-dan-tidak-kosong\" width=\"484\" height=\"385\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/si-la-cellule-est-vide-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/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\/jika-nol-maka-kosong\/\">Centang IF 0 (nol) lalu kosongkan di Excel<\/a><\/li><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-negatif-maka-nol\/\">JIKA negatif maka nol (0) di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1628","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 apakah sel kosong di Excel? (Panduan 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk memeriksa apakah suatu sel kosong atau tidak. Kami akan menggunakan\" \/>\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-selnya-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 apakah sel kosong di Excel? (Panduan 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk memeriksa apakah suatu sel kosong atau tidak. Kami akan menggunakan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.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-selnya-kosong\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\",\"name\":\"Bagaimana cara memeriksa apakah sel kosong di Excel? (Panduan 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.png\",\"datePublished\":\"2023-11-15T02:07:04+00:00\",\"dateModified\":\"2023-12-06T06:14:21+00:00\",\"description\":\"Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk memeriksa apakah suatu sel kosong atau tidak. Kami akan menggunakan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah sel 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 apakah sel kosong di Excel? (Panduan 2023)","description":"Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk memeriksa apakah suatu sel kosong atau tidak. Kami akan menggunakan","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-selnya-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memeriksa apakah sel kosong di Excel? (Panduan 2023)","og_description":"Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk memeriksa apakah suatu sel kosong atau tidak. Kami akan menggunakan","og_url":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.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-selnya-kosong\/","url":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/","name":"Bagaimana cara memeriksa apakah sel kosong di Excel? (Panduan 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.png","datePublished":"2023-11-15T02:07:04+00:00","dateModified":"2023-12-06T06:14:21+00:00","description":"Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk memeriksa apakah suatu sel kosong atau tidak. Kami akan menggunakan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-avec-quelques-cellules-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah sel 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\/1628","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=1628"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1628\/revisions"}],"predecessor-version":[{"id":2346,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1628\/revisions\/2346"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}