{"id":4847,"date":"2023-07-07T07:08:14","date_gmt":"2023-07-07T07:08:14","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/"},"modified":"2023-07-07T07:08:14","modified_gmt":"2023-07-07T07:08:14","slug":"excel-jika-kosong-maka-pindah-ke-sel-berikutnya","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/","title":{"rendered":"Excel: jika sel kosong, pindah ke sel berikutnya"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>IF<\/strong> bersama dengan fungsi <strong>ISLBANK<\/strong> di Excel untuk mengabaikan sel jika kosong saat melakukan perhitungan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISBLANK( <span style=\"color: #3366ff;\">A2<\/span> ), \"\", <span style=\"color: #ff0000;\">B2<\/span> * <span style=\"color: #800080;\">C2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan melakukan hal berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jika sel <strong>A2<\/strong> kosong, cukup kembalikan nilai kosong.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jika sel <strong>A2<\/strong> tidak kosong, kembalikan sel <strong>B2<\/strong> dikalikan dengan sel <strong>C2<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat mengklik dan menyeret rumus ini ke sel lain dalam kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Jika sel kosong, pindah ke sel berikutnya di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah unit yang terjual suatu barang dan harga satuan untuk berbagai karyawan di suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37875 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifb1.png\" alt=\"\" width=\"520\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung total pendapatan yang dihasilkan setiap karyawan dengan cara mengalikan nilai pada kolom <strong>Unit<\/strong> dengan nilai pada kolom <strong>Harga<\/strong> , namun hanya jika sel pada kolom <strong>Karyawan<\/strong> tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISBLANK( <span style=\"color: #3366ff;\">A2<\/span> ), \"\", <span style=\"color: #ff0000;\">B2<\/span> * <span style=\"color: #800080;\">C2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37876\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifb2.png\" alt=\"Excel pindah ke sel berikutnya jika kosong\" width=\"501\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Begini cara kerja rumus ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sel <strong>A2<\/strong> tidak kosong, jadi rumusnya menghasilkan 40 * 4 = 160.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sel <strong>A3<\/strong> tidak kosong, jadi rumusnya menghasilkan 20 * 5 = 100.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sel <strong>A4<\/strong> kosong, sehingga rumus melewatkan penghitungan dan berpindah ke sel berikutnya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sel <strong>A5<\/strong> kosong, sehingga rumus melewatkan penghitungan dan berpindah ke sel berikutnya.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-mengisi-sel-kosong\/\" target=\"_blank\" rel=\"noopener\">Excel: cara mengisi sel kosong<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-sel-kosong-bersyarat-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: menerapkan pemformatan bersyarat ke sel kosong<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-abaikan-nol-dan-kosong\/\" target=\"_blank\" rel=\"noopener\">Excel: hitung rata-rata dan abaikan sel kosong dan kosong<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi IF bersama dengan fungsi ISLBANK di Excel untuk mengabaikan sel jika kosong saat melakukan perhitungan. Misalnya, Anda dapat menggunakan sintaks berikut: =IF(ISBLANK( A2 ), &#8220;&#8221;, B2 * C2 ) Contoh khusus ini akan melakukan hal berikut: Jika sel A2 kosong, cukup kembalikan nilai kosong. Jika sel A2 tidak kosong, kembalikan sel [&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>Excel: jika sel kosong, pindah ke sel berikutnya \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara berpindah ke sel berikutnya dari suatu rumus di Excel jika sel tertentu kosong, beserta 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-jika-kosong-maka-pindah-ke-sel-berikutnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: jika sel kosong, pindah ke sel berikutnya \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara berpindah ke sel berikutnya dari suatu rumus di Excel jika sel tertentu kosong, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T07:08:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifb1.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-jika-kosong-maka-pindah-ke-sel-berikutnya\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/\",\"name\":\"Excel: jika sel kosong, pindah ke sel berikutnya \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T07:08:14+00:00\",\"dateModified\":\"2023-07-07T07:08:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara berpindah ke sel berikutnya dari suatu rumus di Excel jika sel tertentu kosong, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: jika sel kosong, pindah ke sel berikutnya\"}]},{\"@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":"Excel: jika sel kosong, pindah ke sel berikutnya \u2013 Statologi","description":"Tutorial ini menjelaskan cara berpindah ke sel berikutnya dari suatu rumus di Excel jika sel tertentu kosong, beserta 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-jika-kosong-maka-pindah-ke-sel-berikutnya\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: jika sel kosong, pindah ke sel berikutnya \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara berpindah ke sel berikutnya dari suatu rumus di Excel jika sel tertentu kosong, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/","og_site_name":"Statorials","article_published_time":"2023-07-07T07:08:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifb1.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-jika-kosong-maka-pindah-ke-sel-berikutnya\/","url":"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/","name":"Excel: jika sel kosong, pindah ke sel berikutnya \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T07:08:14+00:00","dateModified":"2023-07-07T07:08:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara berpindah ke sel berikutnya dari suatu rumus di Excel jika sel tertentu kosong, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-jika-kosong-maka-pindah-ke-sel-berikutnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: jika sel kosong, pindah ke sel berikutnya"}]},{"@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\/4847"}],"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=4847"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4847\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}