{"id":1819,"date":"2023-11-02T05:46:50","date_gmt":"2023-11-02T05:46:50","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/geen-fout\/"},"modified":"2023-12-06T05:57:05","modified_gmt":"2023-12-06T05:57:05","slug":"geen-fout","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/geen-fout\/","title":{"rendered":"Hoe de #n\/b-fout in excel op te lossen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1900522423\"><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>Er zijn twee situaties bij het omgaan met #N\/A:<\/p><ol type=\"1\"><li> U wilt de fout #N\/A niet krijgen.<\/li><li> Je wilt het niet aan de gebruiker laten zien.<\/li><\/ol><p> Deze tutorial helpt u met deze situaties om te gaan.<\/p><h2 id=\"h-n-a-error-what-does-it-mean\" class=\"wp-block-heading\"> Fout #N\/A \u2013 Wat betekent dit?<\/h2><p> Zoals de naam al doet vermoeden, &#8220;Niet beschikbaar&#8221;. Wanneer u in Excel naar een waarde zoekt met behulp van de zoekfuncties en die waarde niet in de lijst of het bereik wordt gevonden, retourneert uw formule waarschijnlijk het resultaat als een #N\/B-fout. <\/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-fout\" width=\"522\" height=\"307\"><\/figure><\/div><h2 id=\"h-when-you-get-the-n-a\" class=\"wp-block-heading\"> Wanneer krijg je de #N\/A?<\/h2><p> In het bovenstaande voorbeeld hebben we VERT.ZOEKEN gebruikt om de waarde 7 in kolom A te vinden. Maar zoals u kunt zien, valt &#8216;7&#8217; niet binnen het bereik en retourneert de formule #N\/A in het resultaat. <\/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=\"wanneer-je-krijgt-na\" width=\"555\" height=\"325\"><\/figure><\/div><p> Op dezelfde manier retourneert de formule #N\/B in het resultaat wanneer u de functie VERGELIJKEN gebruikt en een overeenkomst probeert te krijgen voor &#8220;7&#8221;. <\/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=\"gebruik-de-match-functie\" width=\"544\" height=\"346\"><\/figure><\/div><p> Afgezien daarvan, als u een andere SEARCH-formule gebruikt, zoals HLOOKUP, SEARCH en INDEX+MATCH, krijgt u ook dezelfde foutmelding.<\/p><p class=\"qt-tip\"> <strong>Opmerking:<\/strong> Met XLOOKUP beschikt u over een ingebouwd argument waarmee u de waarden kunt instellen die u wilt verkrijgen als de waarde die u zoekt niet in het zoekbereik ligt.<\/p><h2 id=\"h-how-to-deal-with-n-a\" class=\"wp-block-heading\"> Hoe #N\/A beheren?<\/h2><p> U kunt twee specifieke functies gebruiken.<\/p><h3 id=\"h-ifna-only-for-n-a-error\" class=\"wp-block-heading\"> IFNA: Alleen voor fout #N\/A<\/h3><p> In het onderstaande voorbeeld hebben we MATCH gebruikt door het te omwikkelen met IFNA. In IFNA gebruikte het eerste argument de MATCH-functie en een waarde die moest worden geretourneerd als MATCH #N\/A retourneert. <\/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=\"match-met-ifna\" width=\"525\" height=\"309\"><\/figure><\/div><h3 id=\"h-iferror-for-all-errors\" class=\"wp-block-heading\"> IFERROR: voor alle fouten<\/h3><p> Ook in het onderstaande voorbeeld hebben we de IFERROR met VLOOKUP gebruikt. We hebben VERT.ZOEKEN verpakt met IFERROR en de waarde gespecificeerd die moet worden geretourneerd als er een fout in het resultaat zit. <\/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-met-vlookup\" width=\"577\" height=\"310\"><\/figure><\/div><h2 id=\"h-other-points-to-remember\" class=\"wp-block-heading\"> Andere punten om te onthouden<\/h2><ol><li> U kunt de waarde die u zoekt het beste controleren met een willekeurige zoekfunctie. Als u een verkeerd gespelde waarde heeft, maar de juiste waarde is aanwezig, zal het moeilijk voor u zijn om dit te weten.<\/li><li> Soms krijgt u mogelijk de foutmelding #N\/A als de waarden die u zoekt een ander formaat hebben dan de waarden die u in het zoekbereik heeft. Als u bijvoorbeeld naar een nummer zoekt, maar dat nummer als tekst in het zoekbereik is opgeslagen, krijgt u nog steeds de foutmelding #N\/B.<\/li><li> De aanwezigheid van extra spaties in de opzoekwaarde of opzoektabelwaarden kan ook resulteren in een #N\/B-fout. <\/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\"> VOORBEELD BESTAND <\/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\">Downloaden<\/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\/nl\/formules\/\">Lijst met Excel-formules<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Gerelateerde formules <\/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\/nl\/delingsfout\/\">Fout #DIV\/0<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/morsfout\/\">#SPREIDING! Fout<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/waarde-fout\/\">#VALUE Fout<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/\">Negeer alle fouten in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/referentie-fout\/\">#REF! Fout<\/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>Hoe de #N\/B-fout in Excel op te lossen? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Deze zelfstudie helpt u de Excel #N\/A-formulefout te begrijpen en op te lossen. Laten we dit controleren...\" \/>\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\/nl\/geen-fout\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe de #N\/B-fout in Excel op te lossen? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Deze zelfstudie helpt u de Excel #N\/A-formulefout te begrijpen en op te lossen. Laten we dit controleren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/geen-fout\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:57:05+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=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/geen-fout\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/geen-fout\/\",\"name\":\"Hoe de #N\/B-fout in Excel op te lossen? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/geen-fout\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/geen-fout\/#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-06T05:57:05+00:00\",\"description\":\"Deze zelfstudie helpt u de Excel #N\/A-formulefout te begrijpen en op te lossen. Laten we dit controleren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/geen-fout\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/geen-fout\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/geen-fout\/#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\/nl\/geen-fout\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe de #n\/b-fout in excel op te lossen?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe de #N\/B-fout in Excel op te lossen? (Tutorial 2023)","description":"Deze zelfstudie helpt u de Excel #N\/A-formulefout te begrijpen en op te lossen. Laten we dit controleren...","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\/nl\/geen-fout\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe de #N\/B-fout in Excel op te lossen? (Tutorial 2023)","og_description":"Deze zelfstudie helpt u de Excel #N\/A-formulefout te begrijpen en op te lossen. Laten we dit controleren...","og_url":"https:\/\/exceladvisor.org\/nl\/geen-fout\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:57:05+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":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/geen-fout\/","url":"https:\/\/exceladvisor.org\/nl\/geen-fout\/","name":"Hoe de #N\/B-fout in Excel op te lossen? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/geen-fout\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/geen-fout\/#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-06T05:57:05+00:00","description":"Deze zelfstudie helpt u de Excel #N\/A-formulefout te begrijpen en op te lossen. Laten we dit controleren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/geen-fout\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/geen-fout\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/geen-fout\/#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\/nl\/geen-fout\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe de #n\/b-fout in excel op te lossen?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1819"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1819\/revisions"}],"predecessor-version":[{"id":2359,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1819\/revisions\/2359"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}