{"id":1819,"date":"2023-11-02T05:46:50","date_gmt":"2023-11-02T05:46:50","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/"},"modified":"2023-12-06T06:14:45","modified_gmt":"2023-12-06T06:14:45","slug":"tidak-ada-kesalahan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/","title":{"rendered":"Bagaimana cara memperbaiki kesalahan #n\/a di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1394251674\"><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>Ada dua situasi ketika berhadapan dengan #N\/A:<\/p><ol type=\"1\"><li> Anda tidak ingin mendapatkan kesalahan #N\/A.<\/li><li> Anda tidak ingin menunjukkannya kepada pengguna.<\/li><\/ol><p> Tutorial ini akan membantu Anda menghadapi situasi ini.<\/p><h2 id=\"h-n-a-error-what-does-it-mean\" class=\"wp-block-heading\"> Kesalahan #N\/A \u2013 Apa artinya ini?<\/h2><p> Seperti namanya, \u201cTidak Tersedia\u201d. Di Excel, saat Anda mencari nilai menggunakan fungsi temukan dan nilai tersebut tidak ditemukan dalam daftar atau rentang, rumus Anda kemungkinan akan mengembalikan hasilnya sebagai kesalahan #N\/A. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82470\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"na-kesalahan\" width=\"522\" height=\"307\"><\/figure><\/div><h2 id=\"h-when-you-get-the-n-a\" class=\"wp-block-heading\"> Kapan Anda mendapatkan #N\/A?<\/h2><p> Dalam contoh di atas, kami menggunakan VLOOKUP untuk mencari nilai 7 di kolom A. Namun seperti yang Anda lihat, &#8220;7&#8221; tidak berada dalam rentang dan rumus mengembalikan #N\/A pada hasilnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82472\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-quand-tu-recois-na.png\" sizes=\"auto, \" srcset=\"\" alt=\"kapan-kamu-mendapatkan-na\" width=\"555\" height=\"325\"><\/figure><\/div><p> Demikian pula, saat Anda menggunakan fungsi MATCH dan mencoba mendapatkan kecocokan untuk &#8220;7&#8221;, rumusnya akan mengembalikan #N\/A pada hasilnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82473\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utiliser-la-fonction-match.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan fungsi pertandingan\" width=\"544\" height=\"346\"><\/figure><\/div><p> Selain itu, jika Anda menggunakan rumus SEARCH lain seperti HLOOKUP, SEARCH dan INDEX+MATCH, Anda juga akan mendapatkan error yang sama.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Dengan XLOOKUP, Anda memiliki argumen bawaan yang memungkinkan Anda mengatur nilai yang akan diperoleh jika nilai yang Anda cari tidak ada dalam rentang pencarian.<\/p><h2 id=\"h-how-to-deal-with-n-a\" class=\"wp-block-heading\"> Bagaimana cara mengelola #N\/A?<\/h2><p> Anda dapat menggunakan dua fungsi spesifik.<\/p><h3 id=\"h-ifna-only-for-n-a-error\" class=\"wp-block-heading\"> IFNA: Hanya untuk kesalahan #N\/A<\/h3><p> Pada contoh dibawah ini, kita menggunakan MATCH dengan membungkusnya dengan IFNA. Di IFNA, argumen pertama menggunakan fungsi MATCH dan nilai yang akan dikembalikan jika MATCH mengembalikan #N\/A. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82475\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-match-avec-ifna.png\" sizes=\"auto, \" srcset=\"\" alt=\"cocok-dengan-ifna\" width=\"525\" height=\"309\"><\/figure><\/div><h3 id=\"h-iferror-for-all-errors\" class=\"wp-block-heading\"> IFERROR: untuk semua kesalahan<\/h3><p> Juga pada contoh di bawah ini kita telah menggunakan IFERROR dengan VLOOKUP. Kami membungkus VLOOKUP dengan IFERROR dan menentukan nilai yang akan dikembalikan jika ada kesalahan pada hasilnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82476\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-iferror-avec-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"iferror-dengan-vlookup\" width=\"577\" height=\"310\"><\/figure><\/div><h2 id=\"h-other-points-to-remember\" class=\"wp-block-heading\"> Hal lain yang perlu diingat<\/h2><ol><li> Yang terbaik adalah memeriksa nilai yang Anda cari dengan fungsi pencarian apa pun. Jika Anda memiliki nilai yang salah eja, tetapi ada nilai yang benar, maka akan sulit bagi Anda untuk mengetahuinya.<\/li><li> Terkadang Anda mungkin mendapatkan kesalahan #N\/A ketika nilai yang Anda cari berada dalam format yang berbeda dari yang Anda miliki di rentang pencarian. Misalnya, jika Anda mencari nomor tetapi nomor tersebut disimpan sebagai teks dalam rentang pencarian, Anda masih akan mendapatkan kesalahan #N\/A.<\/li><li> Adanya spasi ekstra pada nilai pencarian atau nilai tabel pencarian juga dapat mengakibatkan kesalahan #N\/A. <\/li><\/ol><div class=\"gb-container gb-container-bafb25cc\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text\"> CONTOH FILE <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-509e8e50 gb-button-lead-button\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/na-2.xlsx\" rel=\"nofollow\"><span class=\"gb-button-text\">Unduh<\/span><\/a><\/div><\/div><\/div><\/div><\/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\/kesalahan-pembagian\/\">Kesalahan #DIV\/0<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-tumpahan\/\">#MENYEBAR! Kesalahan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/\">#VALUE Kesalahan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengabaikan-kesalahan\/\">Abaikan semua kesalahan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-referensi\/\">#REF! Kesalahan<\/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-1819","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 memperbaiki kesalahan #N\/A di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan membantu Anda memahami dan memperbaiki kesalahan rumus Excel #N\/A. Mari kita periksa ini...\" \/>\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\/tidak-ada-kesalahan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memperbaiki kesalahan #N\/A di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan membantu Anda memahami dan memperbaiki kesalahan rumus Excel #N\/A. Mari kita periksa ini...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/\",\"name\":\"Bagaimana cara memperbaiki kesalahan #N\/A di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png\",\"datePublished\":\"2023-11-02T05:46:50+00:00\",\"dateModified\":\"2023-12-06T06:14:45+00:00\",\"description\":\"Tutorial ini akan membantu Anda memahami dan memperbaiki kesalahan rumus Excel #N\/A. Mari kita periksa ini...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memperbaiki kesalahan #n\/a 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 memperbaiki kesalahan #N\/A di Excel? (Tutorial 2023)","description":"Tutorial ini akan membantu Anda memahami dan memperbaiki kesalahan rumus Excel #N\/A. Mari kita periksa ini...","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\/tidak-ada-kesalahan\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memperbaiki kesalahan #N\/A di Excel? (Tutorial 2023)","og_description":"Tutorial ini akan membantu Anda memahami dan memperbaiki kesalahan rumus Excel #N\/A. Mari kita periksa ini...","og_url":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:45+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/","url":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/","name":"Bagaimana cara memperbaiki kesalahan #N\/A di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png","datePublished":"2023-11-02T05:46:50+00:00","dateModified":"2023-12-06T06:14:45+00:00","description":"Tutorial ini akan membantu Anda memahami dan memperbaiki kesalahan rumus Excel #N\/A. Mari kita periksa ini...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-na-erreur.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memperbaiki kesalahan #n\/a 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\/1819","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=1819"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1819\/revisions"}],"predecessor-version":[{"id":2369,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1819\/revisions\/2369"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}