{"id":1757,"date":"2023-11-06T23:16:52","date_gmt":"2023-11-06T23:16:52","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/"},"modified":"2023-12-06T05:50:30","modified_gmt":"2023-12-06T05:50:30","slug":"fouten-negeren","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/","title":{"rendered":"Hoe negeer je alle fouten in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-810316387\"><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>Om eventuele fouten die u krijgt bij het gebruik van formules te negeren, kunt u in Excel een foutafhandelingsfunctie gebruiken. U kunt uw oorspronkelijke formule omsluiten met een foutafhandelingsfunctie die een betekenisvol resultaat weergeeft wanneer er een fout optreedt. Daarnaast kunt u ook <strong>de optie Negeer de fout in Excel gebruiken<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72420\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"negeer alle fouten\" width=\"669\" height=\"300\"><\/figure><\/div><p> In deze tutorial bekijken we alle methoden die we kunnen gebruiken.<\/p><h2 class=\"wp-block-heading\"> Gebruik IFERROR om fouten te negeren en te vervangen door een betekenisvol bericht<\/h2><p> De beste manier om met fouten om te gaan, is door de functie IFERROR te gebruiken. In deze functie moet u twee argumenten defini\u00ebren. De eerste is de werkelijke waarde die u moet testen op fouten, en vervolgens de waarde die u wilt verkrijgen als er een fout optreedt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72421\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-iferror-pour-ignorer-les-erreurs-de-remplacement.png\" sizes=\"auto, \" srcset=\"\" alt=\"iferror-to-negeer-vervang-fouten\" width=\"515\" height=\"292\"><\/figure><\/div><p> In het volgende voorbeeld kun je zien dat we dezelfde formule hebben gebruikt, maar deze in IFERROR hebben verpakt en de waarde hebben geretourneerd die we hebben ingesteld. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72422\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-iferror-pour-remplacer-toutes-les-erreurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"als er een fout is om alle fouten te vervangen\" width=\"629\" height=\"282\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IFERROR(1\/0,\"There's an error.\")<\/code><\/pre><h2 class=\"wp-block-heading\"> IFNA-functie om #N\/A-fout te negeren<\/h2><p> Als u specifiek de #N\/B-fout wilt negeren en deze wilt vervangen door een betekenisvol bericht, kunt u de IFNA-functie gebruiken die alleen de #N\/B verwerkt. Deze functie heeft ook twee argumenten die u moet defini\u00ebren.<\/p><p> Zoals u in het volgende voorbeeld kunt zien, hebben we de fout in cel D1 die afkomstig is van de functie VERT.ZOEKEN. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72423\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ignorer-aucune-erreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"negeer-#na-fout\" width=\"417\" height=\"330\"><\/figure><\/div><p> Om deze fout op te lossen, kunt u de IFNA gebruiken (u kunt ook <a href=\"https:\/\/exceladvisor.org\/nl\/als-er-een-fout-is-opgetreden\/\">IFERROR gebruiken met de VLOOKUP<\/a> , maar we zullen hier IFNA gebruiken). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72424\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ifna-pour-ignorer-aucune-erreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"ifna-to-ignore-#na-fout\" width=\"586\" height=\"326\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IFNA(VLOOKUP(\"E\",A1:B5,2,0),\"Value is available.\")<\/code><\/pre><h2 class=\"wp-block-heading\"> Negeer optiefout<\/h2><p> Wanneer u een fout in een cel krijgt, geeft Excel u een optie bij die cel waar u de optie \u201cFout negeren\u201d kunt gebruiken. Zoals u in het volgende voorbeeld kunt zien, heeft u een #DIV\/0! fout in cel A1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72425\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-ignorer-lerreur-des-options.png\" sizes=\"auto, \" srcset=\"\" alt=\"negeer-opties-fout\" width=\"350\" height=\"272\"><\/figure><\/div><p> Met cel A1 heb je nu een klein pictogram aan de rechterkant, en als je op dit pictogram klikt, krijg je verder een lijst met opties. En onder deze opties kunt u de optie \u201cFout negeren\u201d selecteren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72426\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-ignorer-les-options-derreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"negeer foutopties\" width=\"340\" height=\"375\"><\/figure><\/div><p> En zodra u op deze optie klikt, stopt Excel met het markeren van die cel als een foutcel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72427\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-erreurs-de-cellule-darret.png\" sizes=\"auto, \" srcset=\"\" alt=\"Stopfout bij celproductie\" width=\"381\" height=\"316\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Opties voor foutcontrole in-\/uitschakelen<\/h2><p> Afgezien hiervan kunt u de foutcontroleopties van Excel Options gebruiken om fouten in Excel op te lossen en te negeren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72428\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-option-de-verification-des-erreurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"optie voor foutcontrole\" width=\"409\" height=\"380\"><\/figure><\/div><p> Wanneer u op &#8220;Opties voor foutcontrole&#8221; klikt, krijgt u het dialoogvenster Excel-opties, van waaruit u de opties voor foutcontrole kunt in- en uitschakelen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72429\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-decochez-activer-la-verification-des-erreurs-en-arriere-plan.png\" sizes=\"auto, \" srcset=\"\" alt=\"verwijder het vinkje bij het inschakelen van achtergrondfoutcontrole\" width=\"718\" height=\"400\"><\/figure><\/div><p> Bij deze opties <strong>moet u het vinkje bij Foutcontrole op achtergrond inschakelen uitschakelen<\/strong> om de opties voor foutcontrole uit te schakelen. Op het moment dat u dit doet, wordt de foutcontrole voor de gehele Excel-applicatie uitgeschakeld. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Haal het Excel-bestand op<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ignorer-toutes-les-erreurs.xlsx\" rel=\"nofollow\">Downloaden<\/a><\/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\/geen-fout\/\">#N.v.t. Fout in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/referentie-fout\/\">#REF! Fout in Excel<\/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-1757","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 negeer je alle fouten in Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie zullen we begrijpen hoe we alle fouten in een cel of bereik die tijdens het gebruik optreden, kunnen negeren\" \/>\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\/fouten-negeren\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe negeer je alle fouten in Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie zullen we begrijpen hoe we alle fouten in een cel of bereik die tijdens het gebruik optreden, kunnen negeren\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.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\/fouten-negeren\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/\",\"name\":\"Hoe negeer je alle fouten in Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.png\",\"datePublished\":\"2023-11-06T23:16:52+00:00\",\"dateModified\":\"2023-12-06T05:50:30+00:00\",\"description\":\"In deze zelfstudie zullen we begrijpen hoe we alle fouten in een cel of bereik die tijdens het gebruik optreden, kunnen negeren\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe negeer je alle fouten in excel?\"}]},{\"@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 negeer je alle fouten in Excel? (Tutorial 2023)","description":"In deze zelfstudie zullen we begrijpen hoe we alle fouten in een cel of bereik die tijdens het gebruik optreden, kunnen negeren","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\/fouten-negeren\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe negeer je alle fouten in Excel? (Tutorial 2023)","og_description":"In deze zelfstudie zullen we begrijpen hoe we alle fouten in een cel of bereik die tijdens het gebruik optreden, kunnen negeren","og_url":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.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\/fouten-negeren\/","url":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/","name":"Hoe negeer je alle fouten in Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.png","datePublished":"2023-11-06T23:16:52+00:00","dateModified":"2023-12-06T05:50:30+00:00","description":"In deze zelfstudie zullen we begrijpen hoe we alle fouten in een cel of bereik die tijdens het gebruik optreden, kunnen negeren","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/fouten-negeren\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ignorer-toutes-les-erreurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/fouten-negeren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe negeer je alle fouten in excel?"}]},{"@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\/1757","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=1757"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1757\/revisions"}],"predecessor-version":[{"id":2740,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1757\/revisions\/2740"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}