{"id":2954,"date":"2023-07-19T22:28:12","date_gmt":"2023-07-19T22:28:12","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-iferror-kosong\/"},"modified":"2023-07-19T22:28:12","modified_gmt":"2023-07-19T22:28:12","slug":"excel-iferror-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-iferror-kosong\/","title":{"rendered":"Excel: cara menggunakan iferror lalu dikosongkan"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan metode berikut ini di Excel untuk mengembalikan nilai kosong dan bukan nilai kesalahan ketika nilai yang valid tidak dikembalikan oleh rumus:<\/span><\/p>\n

Cara 1: IFERROR kemudian dikosongkan dengan rumus<\/strong><\/span><\/p>\n

 =IFERROR( B2<\/span> \/ A2<\/span> , \"\")\n<\/strong><\/pre>\n
 Cara 2: IFERROR lalu kosongkan dengan VLOOKUP<\/strong><\/span><\/p>\n
 =IFERROR(VLOOKUP( E2<\/span> , $A$2:$C$12<\/span> , 3, FALSE), \"\")\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n
 Contoh 1: IFERROR lalu dikosongkan dengan rumus<\/strong><\/span><\/h3>\n
 Misalkan kita menggunakan rumus berikut untuk membagi nilai di kolom B dengan nilai di kolom A pada lembar kerja Excel khusus ini:<\/span> <\/p>\n
 = B2<\/span> \/ A2<\/span><\/strong> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa untuk setiap sel di kolom C di mana kita mencoba membaginya dengan nilai kosong, kita menerima #DIV\/0!<\/strong> Karena itu.<\/span><\/p>\n
 Untuk mengembalikan nilai kosong dan bukan nilai kesalahan, 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
\"\"<\/p>\n
 Sekarang untuk setiap sel di kolom C tempat kita mencoba membagi dengan nilai kosong, kita hanya menerima nilai kosong.<\/span><\/p>\n
 Contoh 2: IFERROR lalu kosongkan dengan VLOOKUP<\/strong><\/span><\/h3>\n
 Misalkan kita menggunakan rumus VLOOKUP<\/strong> berikut untuk mencari nama pemain di kolom A dan mengembalikan nilai rebound di kolom C:<\/span> <\/p>\n
 VLOOKUP( F2<\/span> , $A$2:$C$12<\/span> , 3, FALSE)<\/strong> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa untuk setiap sel di kolom G di mana kita menemukan nilai kosong di fungsi VLOOKUP<\/strong> , kita menerima #N\/A<\/strong> yang sesuai.<\/span><\/p>\n
 Untuk mengembalikan nilai kosong dan bukan nilai #N\/A<\/strong> , kita bisa mengetikkan rumus berikut di sel F2<\/strong> :<\/span><\/p>\n
 =IFERROR(VLOOKUP( F2<\/span> , $A$2:$C$12<\/span> , 3, FALSE), \"\")<\/strong><\/pre>\n
 Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom F:<\/span> <\/p>\n
\"IFERROR<\/p>\n
 Sekarang untuk setiap sel tempat kita menemukan nilai kosong di fungsi VLOOKUP<\/strong> , kita cukup menerima nilai kosong.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Cara mengabaikan nilai #N\/A saat menggunakan rumus di Excel<\/a>
 Bagaimana cara mengganti nilai #N\/A di Excel<\/a>
 Cara Memperbaiki Kesalahan #NAME di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan metode berikut ini di Excel untuk mengembalikan nilai kosong dan bukan nilai kesalahan ketika nilai yang valid tidak dikembalikan oleh rumus: Cara 1: IFERROR kemudian dikosongkan dengan rumus =IFERROR( B2 \/ A2 , “”) Cara 2: IFERROR lalu kosongkan dengan VLOOKUP =IFERROR(VLOOKUP( E2 , $A$2:$C$12 , 3, FALSE), “”) Contoh berikut menunjukkan […]<\/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":"\nExcel: Cara menggunakan IFERROR lalu blank - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat rumus menggunakan IFERROR lalu blank di Excel, disertai 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\/excel-iferror-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan IFERROR lalu blank - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat rumus menggunakan IFERROR lalu blank di Excel, disertai beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-iferror-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T22:28:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sierreur11-1.jpg\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-iferror-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-iferror-kosong\/\",\"name\":\"Excel: Cara menggunakan IFERROR lalu blank - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T22:28:12+00:00\",\"dateModified\":\"2023-07-19T22:28:12+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat rumus menggunakan IFERROR lalu blank di Excel, disertai beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-iferror-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-iferror-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-iferror-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan iferror lalu dikosongkan\"}]},{\"@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: Cara menggunakan IFERROR lalu blank - Statorials","description":"Tutorial ini menjelaskan cara membuat rumus menggunakan IFERROR lalu blank di Excel, disertai 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\/excel-iferror-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan IFERROR lalu blank - Statorials","og_description":"Tutorial ini menjelaskan cara membuat rumus menggunakan IFERROR lalu blank di Excel, disertai beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-iferror-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-19T22:28:12+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sierreur11-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-iferror-kosong\/","url":"https:\/\/statorials.org\/id\/excel-iferror-kosong\/","name":"Excel: Cara menggunakan IFERROR lalu blank - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T22:28:12+00:00","dateModified":"2023-07-19T22:28:12+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat rumus menggunakan IFERROR lalu blank di Excel, disertai beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-iferror-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-iferror-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-iferror-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan iferror lalu dikosongkan"}]},{"@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\/2954"}],"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=2954"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2954\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}