{"id":344,"date":"2023-11-02T05:46:50","date_gmt":"2023-11-02T05:46:50","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/"},"modified":"2023-12-06T11:36:33","modified_gmt":"2023-12-06T11:36:33","slug":"nao-ha-erro","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/","title":{"rendered":"Como corrigir o erro #n\/a no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3733664685\"><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><div class=\"excel-before-content\" id=\"excel-186788881\"><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>Existem duas situa\u00e7\u00f5es ao lidar com #N\/A:<\/p><ol type=\"1\"><li> Voc\u00ea n\u00e3o deseja obter o erro #N\/A.<\/li><li> Voc\u00ea n\u00e3o quer mostrar isso ao usu\u00e1rio.<\/li><\/ol><p> Este tutorial ir\u00e1 ajud\u00e1-lo a lidar com essas situa\u00e7\u00f5es.<\/p><h2 id=\"h-n-a-error-what-does-it-mean\" class=\"wp-block-heading\"> Erro #N\/A \u2013 O que isso significa?<\/h2><p> Como o nome sugere, \u201cN\u00e3o dispon\u00edvel\u201d. No Excel, quando voc\u00ea pesquisa um valor usando as fun\u00e7\u00f5es de localiza\u00e7\u00e3o e esse valor n\u00e3o \u00e9 encontrado na lista ou intervalo, sua f\u00f3rmula provavelmente retornar\u00e1 o resultado como um erro #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-erro\" width=\"522\" height=\"307\"><\/figure><\/div><h2 id=\"h-when-you-get-the-n-a\" class=\"wp-block-heading\"> Quando voc\u00ea recebe o #N\/A?<\/h2><p> No exemplo acima, usamos VLOOKUP para encontrar o valor 7 na coluna A. Mas como voc\u00ea pode ver, \u201c7\u201d n\u00e3o est\u00e1 no intervalo e a f\u00f3rmula retorna #N\/A no resultado. <\/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=\"quando voc\u00ea chegar\" width=\"555\" height=\"325\"><\/figure><\/div><p> Da mesma forma, quando voc\u00ea usa a fun\u00e7\u00e3o MATCH e tenta obter uma correspond\u00eancia para \u201c7\u201d, a f\u00f3rmula retorna #N\/A no resultado. <\/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=\"use a fun\u00e7\u00e3o de correspond\u00eancia\" width=\"544\" height=\"346\"><\/figure><\/div><p> Al\u00e9m disso, se voc\u00ea usar qualquer outra f\u00f3rmula de PESQUISA como HLOOKUP, PESQUISA e \u00cdNDICE + CORRESP, tamb\u00e9m receber\u00e1 o mesmo erro.<\/p><p class=\"qt-tip\"> <strong>Nota:<\/strong> Com XLOOKUP, voc\u00ea tem um argumento embutido que permite definir os valores a serem obtidos se o valor que voc\u00ea est\u00e1 procurando n\u00e3o estiver no intervalo de pesquisa.<\/p><h2 id=\"h-how-to-deal-with-n-a\" class=\"wp-block-heading\"> Como gerenciar #N\/A?<\/h2><p> Voc\u00ea pode usar duas fun\u00e7\u00f5es espec\u00edficas.<\/p><h3 id=\"h-ifna-only-for-n-a-error\" class=\"wp-block-heading\"> IFNA: Somente para erro #N\/A<\/h3><p> No exemplo abaixo, usamos MATCH envolvendo-o com IFNA. Em IFNA, o primeiro argumento usou a fun\u00e7\u00e3o MATCH e um valor a ser retornado se MATCH retornar #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=\"combinar com ifna\" width=\"525\" height=\"309\"><\/figure><\/div><h3 id=\"h-iferror-for-all-errors\" class=\"wp-block-heading\"> IFERROR: para todos os erros<\/h3><p> Tamb\u00e9m no exemplo abaixo usamos o IFERROR com VLOOKUP. Envolvemos VLOOKUP com IFERROR e especificamos o valor a ser retornado se houver um erro no resultado. <\/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-com-vlookup\" width=\"577\" height=\"310\"><\/figure><\/div><h2 id=\"h-other-points-to-remember\" class=\"wp-block-heading\"> Outros pontos a serem lembrados<\/h2><ol><li> \u00c9 melhor verificar o valor que voc\u00ea procura com qualquer fun\u00e7\u00e3o de pesquisa. Se voc\u00ea tiver um valor digitado incorretamente, mas o valor correto estiver l\u00e1, ser\u00e1 dif\u00edcil saber.<\/li><li> \u00c0s vezes, voc\u00ea pode receber o erro #N\/A quando os valores que voc\u00ea est\u00e1 procurando est\u00e3o em um formato diferente daqueles que voc\u00ea possui no intervalo de pesquisa. Por exemplo, se voc\u00ea pesquisar um n\u00famero, mas esse n\u00famero for salvo como texto no intervalo de pesquisa, voc\u00ea ainda receber\u00e1 o erro #N\/A.<\/li><li> A presen\u00e7a de espa\u00e7os extras no valor de pesquisa ou nos valores da tabela de pesquisa tamb\u00e9m pode resultar em um erro #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\"> ARQUIVO DE EXEMPLO <\/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\">Download<\/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\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/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\/pt\/erro-de-divisao\/\">Erro #DIV\/0<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/erro-de-derramamento\/\">#ESPALHAR! Erro<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/erro-de-valor\/\">#VALUE Erro<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/ignorar-erros\/\">Ignore todos os erros no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/erro-de-referencia\/\">#REF! Erro<\/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-344","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>Como corrigir o erro #N\/A no Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Este tutorial ir\u00e1 ajud\u00e1-lo a entender e corrigir o erro de f\u00f3rmula #N\/A do Excel. Vamos verificar isso...\" \/>\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\/pt\/nao-ha-erro\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como corrigir o erro #N\/A no Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Este tutorial ir\u00e1 ajud\u00e1-lo a entender e corrigir o erro de f\u00f3rmula #N\/A do Excel. Vamos verificar isso...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:36:33+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=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/\",\"name\":\"Como corrigir o erro #N\/A no Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#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-06T11:36:33+00:00\",\"description\":\"Este tutorial ir\u00e1 ajud\u00e1-lo a entender e corrigir o erro de f\u00f3rmula #N\/A do Excel. Vamos verificar isso...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#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\/pt\/nao-ha-erro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como corrigir o erro #n\/a no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como corrigir o erro #N\/A no Excel? (Tutorial 2023)","description":"Este tutorial ir\u00e1 ajud\u00e1-lo a entender e corrigir o erro de f\u00f3rmula #N\/A do Excel. Vamos verificar isso...","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\/pt\/nao-ha-erro\/","og_locale":"pt_PT","og_type":"article","og_title":"Como corrigir o erro #N\/A no Excel? (Tutorial 2023)","og_description":"Este tutorial ir\u00e1 ajud\u00e1-lo a entender e corrigir o erro de f\u00f3rmula #N\/A do Excel. Vamos verificar isso...","og_url":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:36:33+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":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/","url":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/","name":"Como corrigir o erro #N\/A no Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#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-06T11:36:33+00:00","description":"Este tutorial ir\u00e1 ajud\u00e1-lo a entender e corrigir o erro de f\u00f3rmula #N\/A do Excel. Vamos verificar isso...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/nao-ha-erro\/#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\/pt\/nao-ha-erro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como corrigir o erro #n\/a no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=344"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/344\/revisions"}],"predecessor-version":[{"id":966,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/344\/revisions\/966"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}