{"id":10968,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/e-cel-vazia\/"},"modified":"2021-02-25T17:22:30","modified_gmt":"2021-02-25T17:22:30","slug":"isblank","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/isblank\/","title":{"rendered":"\u00c9.C\u00c9L.VAZIA"},"content":{"rendered":"<h2>Introdu\u00e7\u00e3o<\/h2>\n<p>A fun\u00e7\u00e3o ISBLANK (no Google Planilhas) ou \u00c9.C\u00c9L.VAZIA (no Microsoft Excel) verifica se uma c\u00e9lula est\u00e1 vazia. Esse recurso \u00e9 extremamente \u00fatil para identificar c\u00e9lulas que n\u00e3o cont\u00eam dados dentro de um grande conjunto de informa\u00e7\u00f5es, desempenhando um papel crucial para an\u00e1lises precisas e para a tomada de decis\u00f5es baseada em dados.<\/p>\n<h2>Sintaxe e Exemplos<\/h2>\n<p>A sintaxe para esta fun\u00e7\u00e3o \u00e9 simples:<\/p>\n<ul>\n<li><strong>Excel:<\/strong> <code>=\u00c9.C\u00c9L.VAZIA(c\u00e9lula)<\/code><\/li>\n<li><strong>Google Planilhas:<\/strong> <code>=ISBLANK(c\u00e9lula)<\/code><\/li>\n<\/ul>\n<p>O termo <em>c\u00e9lula<\/em> refere-se \u00e0 refer\u00eancia da c\u00e9lula que voc\u00ea deseja verificar.<\/p>\n<p>Exemplos:<\/p>\n<pre><code>Se A1 est\u00e1 vazia: Excel: =\u00c9.C\u00c9L.VAZIA(A1) retorna VERDADEIRO Google Planilhas: =ISBLANK(A1) retorna TRUE Se A1 cont\u00e9m algum valor ou f\u00f3rmula: Excel: =\u00c9.C\u00c9L.VAZIA(A1) retornar\u00e1 FALSO Google Planilhas: =ISBLANK(A1) retorna FALSE<\/code><\/pre>\n<h2>Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n<p>A fun\u00e7\u00e3o ISBLANK ou \u00c9.C\u00c9L.VAZIA pode ser utilizada em diversas situa\u00e7\u00f5es, tais como:<\/p>\n<h2>Verifica\u00e7\u00e3o de Entrada de Dados<\/h2>\n<p>\u00c9 comum precisarmos certificar que todos os dados necess\u00e1rios foram inseridos em uma planilha. Por exemplo, suponha que as c\u00e9lulas de A1 a A10 devam ser preenchidas:<\/p>\n<pre><code>F\u00f3rmula para verificar se todos os dados foram inseridos: =SE(PRODUTO(SE(\u00c9.C\u00c9L.VAZIA(A1:A10); 0; 1)); \"Completo\"; \"Incompleto\")<\/code><\/pre>\n<p>Esta f\u00f3rmula aplica a fun\u00e7\u00e3o PRODUTO no Excel, convertendo todos os resultados VERDADEIRO (de \u00c9.C\u00c9L.VAZIA) em 0 e os FALSO em 1. Se qualquer resultado for 0, a resposta final ser\u00e1 &#8220;Incompleto&#8221;.<\/p>\n<h2>Limpeza de Dados<\/h2>\n<p>Outra aplica\u00e7\u00e3o frequente \u00e9 na limpeza de conjuntos de dados, onde c\u00e9lulas vazias podem ser preenchidas com um valor padr\u00e3o ou eliminadas do conjunto para evitar erros de an\u00e1lise. Por exemplo, para preencher c\u00e9lulas vazias com o texto &#8220;N\/A&#8221;:<\/p>\n<pre><code>Para Excel: =SE(\u00c9.C\u00c9L.VAZIA(A1); \"N\/A\"; A1) Para Google Planilhas: =SE(ISBLANK(A1); \"N\/A\"; A1)<\/code><\/pre>\n<p>Essa f\u00f3rmula verifica se a c\u00e9lula A1 est\u00e1 vazia, e se sim, insere &#8220;N\/A&#8221;. Caso contr\u00e1rio, mant\u00e9m o valor original de A1.<\/p>\n<h2>Conclus\u00e3o<\/h2>\n<p>Compreender e utilizar a fun\u00e7\u00e3o ISBLANK ou \u00c9.C\u00c9L.VAZIA pode aumentar significativamente a efici\u00eancia ao manipular grandes volumes de dados no Excel e Google Planilhas. A fun\u00e7\u00e3o, apesar de simples, possui uma aplicabilidade vasta e pode ser extremamente \u00fatil em diversas tarefas de manipula\u00e7\u00e3o e an\u00e1lise de dados.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devolve VERDADEIRO se o valor estiver em branco<\/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-10968","post","type-post","status-publish","format-standard","hentry","category-informacoes"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) 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\/isblank\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/isblank\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:22:30+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 ISBLANK (\u00c9.C\u00c9L.VAZIA) 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\/isblank\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/isblank\/\",\"name\":\"Fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:22:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/isblank\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/isblank\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/isblank\/#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\":\"\u00c9.C\u00c9L.VAZIA\"}]},{\"@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 ISBLANK (\u00c9.C\u00c9L.VAZIA) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) 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\/isblank\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/isblank\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:22:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) 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\/isblank\/","url":"https:\/\/functiontranslator.com\/pt-pt\/isblank\/","name":"Fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:22:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISBLANK (\u00c9.C\u00c9L.VAZIA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/isblank\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/isblank\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/isblank\/#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":"\u00c9.C\u00c9L.VAZIA"}]},{"@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\/10968","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=10968"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10968\/revisions"}],"predecessor-version":[{"id":25797,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10968\/revisions\/25797"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}