{"id":2955,"date":"2023-07-19T22:21:54","date_gmt":"2023-07-19T22:21:54","guid":{"rendered":"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/"},"modified":"2023-07-19T22:21:54","modified_gmt":"2023-07-19T22:21:54","slug":"iferror-bersarang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/","title":{"rendered":"Cara menulis pernyataan iferror bersarang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menulis pernyataan IFERROR bertingkat di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR(VLOOKUP( <span style=\"color: #3366ff;\">G2<\/span> , <span style=\"color: #ff0000;\">A2:B6<\/span> ,2,0),IFERROR(VLOOKUP( <span style=\"color: #3366ff;\">G2<\/span> , <span style=\"color: #800080;\">D2:E6<\/span> ,2,0), \"\"))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mencari nilai di sel <strong>G2<\/strong> dalam rentang <strong>A2:B6<\/strong> dan mencoba mengembalikan nilai terkait di kolom kedua rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai sel <strong>G2<\/strong> tidak ditemukan di rentang pertama, maka Excel akan mencarinya di rentang <strong>D2:E6<\/strong> dan mengembalikan nilai yang cocok di kolom kedua rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai di sel <strong>G2<\/strong> juga tidak ditemukan dalam rentang ini, spasi akan dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Tulis pernyataan IFERROR bertingkat di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25638 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nested_iferror1.jpg\" alt=\"\" width=\"530\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menulis pernyataan IFERROR bertingkat berikut untuk mengembalikan nilai poin yang terkait dengan tim yang berbeda:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR(VLOOKUP( <span style=\"color: #3366ff;\">G2<\/span> , <span style=\"color: #ff0000;\">$A$2:$B$6<\/span> ,2,0),IFERROR(VLOOKUP( <span style=\"color: #3366ff;\">G2<\/span> , <span style=\"color: #800080;\">$D$2:$E$6<\/span> ,2,0), \"\"))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25639\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nested_iferror2.jpg\" alt=\"Pernyataan IFERROR bersarang di Excel\" width=\"677\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Rumus ini pertama-tama mencari nama tim di kolom G dalam rentang <strong>A2:B6<\/strong> dan mencoba mengembalikan nilai poin yang sesuai.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika rumus tidak menemukan nama tim dalam rentang <strong>A2:B6<\/strong> , maka rumus akan mencari dalam rentang <strong>D2:E6<\/strong> dan mencoba mengembalikan nilai poin yang sesuai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak menemukan nama tim dalam rentang mana pun, ia hanya mengembalikan nilai kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nama tim &#8220;Raja&#8221; tidak ada di kedua rentang tersebut, sehingga nilai poin untuk tim ini hanyalah nilai kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Untuk contoh ini, kita membuat pernyataan IFERROR bertingkat dengan dua fungsi VLOOKUP, namun kita dapat menggunakan fungsi VLOOKUP sebanyak yang kita inginkan bergantung pada jumlah rentang unik yang sedang kita proses.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/vlookup-membandingkan-dua-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara Membandingkan Dua Daftar di Excel Menggunakan VLOOKUP<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-mengembalikan-semua-kecocokan\/\" target=\"_blank\" rel=\"noopener\">Cara Menggunakan VLOOKUP untuk Mengembalikan Semua Kecocokan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-mengembalikan-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara Menggunakan VLOOKUP untuk Mengembalikan Banyak Kolom di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menulis pernyataan IFERROR bertingkat di Excel: =IFERROR(VLOOKUP( G2 , A2:B6 ,2,0),IFERROR(VLOOKUP( G2 , D2:E6 ,2,0), &#8220;&#8221;)) Rumus khusus ini mencari nilai di sel G2 dalam rentang A2:B6 dan mencoba mengembalikan nilai terkait di kolom kedua rentang tersebut. Jika nilai sel G2 tidak ditemukan di rentang pertama, maka Excel akan [&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 menulis pernyataan IFERROR bertingkat di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menulis pernyataan IFERROR bertingkat di Excel, 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\/iferror-bersarang-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menulis pernyataan IFERROR bertingkat di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menulis pernyataan IFERROR bertingkat di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T22:21:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nested_iferror1.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\/iferror-bersarang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/\",\"name\":\"Cara menulis pernyataan IFERROR bertingkat di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T22:21:54+00:00\",\"dateModified\":\"2023-07-19T22:21:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menulis pernyataan IFERROR bertingkat di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menulis pernyataan iferror bersarang 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 menulis pernyataan IFERROR bertingkat di Excel - Statorials","description":"Tutorial ini menjelaskan cara menulis pernyataan IFERROR bertingkat di Excel, 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\/iferror-bersarang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menulis pernyataan IFERROR bertingkat di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menulis pernyataan IFERROR bertingkat di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T22:21:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nested_iferror1.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\/iferror-bersarang-excel\/","url":"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/","name":"Cara menulis pernyataan IFERROR bertingkat di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T22:21:54+00:00","dateModified":"2023-07-19T22:21:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menulis pernyataan IFERROR bertingkat di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/iferror-bersarang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/iferror-bersarang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menulis pernyataan iferror bersarang 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\/2955"}],"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=2955"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2955\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}