{"id":11025,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/nao-disp\/"},"modified":"2021-02-25T17:25:05","modified_gmt":"2021-02-25T17:25:05","slug":"na","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/na\/","title":{"rendered":"N\u00c3O.DISP"},"content":{"rendered":"

A fun\u00e7\u00e3o N\u00c3O.DISP, utilizada tanto no Microsoft Excel quanto no Google Sheets, \u00e9 essencial para indicar valores que est\u00e3o “N\u00e3o Dispon\u00edveis”. Essa fun\u00e7\u00e3o \u00e9 particularmente \u00fatil em diversas situa\u00e7\u00f5es, como na manipula\u00e7\u00e3o de dados incompletos ou na an\u00e1lise de erros em f\u00f3rmulas.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

No Excel e no Google Sheets, a fun\u00e7\u00e3o N\u00c3O.DISP \u00e9 muito simples, pois n\u00e3o requer nenhum argumento. A sintaxe \u00e9 a seguinte:<\/p>\n

=N\u00c3O.DISP()<\/code><\/pre>\n
Ao inserir essa fun\u00e7\u00e3o em uma c\u00e9lula, ela exibe o erro #N\/D, indicando que o valor n\u00e3o est\u00e1 dispon\u00edvel. Isso \u00e9 \u00fatil para marcar c\u00e9lulas onde os dados est\u00e3o faltando ou n\u00e3o devem ser contabilizados em c\u00e1lculos.<\/p>\n
Exemplo:<\/p>\n
    \n
  • Imagine que voc\u00ea esteja compilando uma lista de vendas e alguns produtos ainda n\u00e3o foram vendidos, logo, os dados de vendas desses produtos est\u00e3o faltando. A fun\u00e7\u00e3o N\u00c3O.DISP pode ser usada para preencher essas lacunas.<\/li>\n<\/ul>\n
    A1: Produto A2: Televis\u00e3o A3: Celular A4: Laptop B1: Vendas B2: 25 B3: N\u00c3O.DISP() B4: 15 <\/code><\/pre>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Caso 1: Tratamento de dados faltantes em c\u00e1lculos<\/h2>\n
    Suponha que voc\u00ea esteja tentando calcular a m\u00e9dia de vendas, mas alguns produtos ainda n\u00e3o possuem dados de vendas registrados. A fun\u00e7\u00e3o N\u00c3O.DISP pode ser utilizada para desconsiderar esses produtos nos c\u00e1lculos da m\u00e9dia.<\/p>\n
    A1: Produto A2: Televis\u00e3o A3: Celular A4: Laptop B1: Vendas B2: 25 B3: N\u00c3O.DISP() B4: 15 C1: M\u00e9dia de Vendas C2: =M\u00c9DIA(B2:B4) <\/code><\/pre>\n
    Coment\u00e1rio: Note que a fun\u00e7\u00e3o M\u00c9DIA automaticamente desconsidera c\u00e9lulas com o erro #N\/D. Assim, a m\u00e9dia \u00e9 calculada apenas com os valores 25 e 15.<\/p>\n
    Caso 2: Prepara\u00e7\u00e3o de dados para an\u00e1lise<\/h2>\n
    Vamos considerar que voc\u00ea esteja preparando um relat\u00f3rio e precise identificar claramente onde os dados est\u00e3o faltando. A fun\u00e7\u00e3o N\u00c3O.DISP \u00e9 ideal para visualizar essas lacunas claramente.<\/p>\n
    A1: M\u00eas A2: Janeiro A3: Fevereiro A4: Mar\u00e7o B1: Receita B2: 5000 B3: N\u00c3O.DISP() B4: 4700 C1: Coment\u00e1rio C2: Completo C3: Dados faltando C4: Completo <\/code><\/pre>\n
    Coment\u00e1rio: Aqui, a fun\u00e7\u00e3o N\u00c3O.DISP() \u00e9 usada para destacar visualmente a falta de dados para Fevereiro na coluna “Coment\u00e1rio”.<\/p>\n
    O uso da fun\u00e7\u00e3o N\u00c3O.DISP \u00e9 crucial para uma representa\u00e7\u00e3o adequada de dados ausentes em planilhas, o que facilita a an\u00e1lise e previne erros em c\u00e1lculos que poderiam ocorrer se fossem utilizados dados incompletos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve o valor de erro #N\/D<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[446],"tags":[],"class_list":["post-11025","post","type-post","status-publish","format-standard","hentry","category-informacoes"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NA (N\u00c3O.DISP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pt-pt\/na\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NA (N\u00c3O.DISP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/na\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:25:05+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/na\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/na\/\",\"name\":\"Fun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:25:05+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NA (N\u00c3O.DISP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/na\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/na\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/na\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informa\u00e7\u00f5es\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/informacoes\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"N\u00c3O.DISP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NA (N\u00c3O.DISP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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:\/\/functiontranslator.com\/pt-pt\/na\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NA (N\u00c3O.DISP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/na\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:25:05+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/na\/","url":"https:\/\/functiontranslator.com\/pt-pt\/na\/","name":"Fun\u00e7\u00e3o NA (N\u00c3O.DISP) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:25:05+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NA (N\u00c3O.DISP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/na\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/na\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/na\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Informa\u00e7\u00f5es","item":"https:\/\/functiontranslator.com\/pt-pt\/informacoes\/"},{"@type":"ListItem","position":3,"name":"N\u00c3O.DISP"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11025"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11025\/revisions"}],"predecessor-version":[{"id":25854,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11025\/revisions\/25854"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}