{"id":4138,"date":"2023-07-13T08:26:32","date_gmt":"2023-07-13T08:26:32","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/"},"modified":"2023-07-13T08:26:32","modified_gmt":"2023-07-13T08:26:32","slug":"excel-memeriksa-apakah-sel-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/","title":{"rendered":"Bagaimana cara memeriksa apakah sel kosong di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk memeriksa apakah sel kosong di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Periksa apakah sel kosong<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">IF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">ISBLANK<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"Empty\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"Not Empty\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Jika sel <strong>A1<\/strong> kosong, rumus ini mengembalikan &#8220;Kosong&#8221; dan jika tidak, rumus mengembalikan &#8220;Tidak kosong&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Periksa apakah beberapa sel kosong<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">IF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(AND(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">ISBLANK<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">), ISBLANK( <span style=\"color: #ff0000;\">B1<\/span> ))<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201cEmpty\u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201cNot Empty\u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Jika sel <strong>A1<\/strong> dan <strong>B1<\/strong> keduanya kosong, rumus ini akan mengembalikan &#8220;Kosong&#8221;. Jika tidak, ia akan mengembalikan &#8220;Tidak kosong&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode di Excel.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Contoh 1: Periksa apakah sel kosong<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32878 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty1.png\" alt=\"\" width=\"465\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan menggunakan rumus berikut untuk memeriksa apakah setiap sel di kolom A kosong:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">IF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">ISBLANK<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"Empty\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"Not Empty\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>B2<\/strong> , lalu menyalin dan menempelkannya ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32879\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty2.png\" alt=\"Excel memeriksa apakah sel kosong\" width=\"499\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai di kolom B memberi tahu kita apakah setiap nilai terkait di kolom A kosong atau tidak.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Contoh 2: Periksa apakah beberapa sel kosong<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32880 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty3.png\" alt=\"\" width=\"496\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan menggunakan rumus berikut untuk memeriksa apakah sel di kolom A dan B kosong:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">IF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(AND(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">ISBLANK<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">), ISBLANK( <span style=\"color: #ff0000;\">B2<\/span> ))<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201cEmpty\u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201cNot Empty\u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan memasukkan rumus ini di sel <strong>C2<\/strong> , lalu salin dan tempel ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32881\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty4.png\" alt=\"Excel memeriksa apakah beberapa sel kosong\" width=\"606\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai di kolom C memberi tahu kita apakah dua nilai yang bersesuaian di kolom A dan kolom B kosong atau tidak.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\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-memeriksa-apakah-rentang-tersebut-berisi-nilai\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara memeriksa apakah rentang berisi nilai tertentu<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/excel-jika-berisi-sebagian-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memeriksa apakah sel berisi sebagian teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara memeriksa apakah nilai kolom ada di kolom lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk memeriksa apakah sel kosong di Excel: Metode 1: Periksa apakah sel kosong = IF ( ISBLANK ( A1 ) , &#8220;Empty&#8221; , &#8220;Not Empty&#8221; ) Jika sel A1 kosong, rumus ini mengembalikan &#8220;Kosong&#8221; dan jika tidak, rumus mengembalikan &#8220;Tidak kosong&#8221;. Metode 2: Periksa apakah beberapa sel kosong = IF [&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>Cara memeriksa apakah suatu sel kosong di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah sel kosong di Excel, dengan sebuah 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\/excel-memeriksa-apakah-sel-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memeriksa apakah suatu sel kosong di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah sel kosong di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T08:26:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty1.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\/excel-memeriksa-apakah-sel-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/\",\"name\":\"Cara memeriksa apakah suatu sel kosong di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T08:26:32+00:00\",\"dateModified\":\"2023-07-13T08:26:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memeriksa apakah sel kosong di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah sel kosong 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":"Cara memeriksa apakah suatu sel kosong di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara memeriksa apakah sel kosong di Excel, dengan sebuah 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\/excel-memeriksa-apakah-sel-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memeriksa apakah suatu sel kosong di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara memeriksa apakah sel kosong di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-13T08:26:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/checkempty1.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\/excel-memeriksa-apakah-sel-kosong\/","url":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/","name":"Cara memeriksa apakah suatu sel kosong di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T08:26:32+00:00","dateModified":"2023-07-13T08:26:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memeriksa apakah sel kosong di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah sel kosong 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\/4138"}],"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=4138"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4138\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}