{"id":10972,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/e-formula\/"},"modified":"2021-02-25T17:22:38","modified_gmt":"2021-02-25T17:22:38","slug":"isformula","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/isformula\/","title":{"rendered":"\u00c9.FORMULA"},"content":{"rendered":"<h2>Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o \u00c9.FORMULA<\/h2>\n<p>A fun\u00e7\u00e3o <code>ISFORMULA<\/code> no Excel, ou <code>\u00c9.FORMULA<\/code> no Google Planilhas, \u00e9 usada para verificar se uma c\u00e9lula espec\u00edfica cont\u00e9m uma f\u00f3rmula. Esta fun\u00e7\u00e3o \u00e9 particularmente \u00fatil em planilhas complexas, pois possibilita diferenciar c\u00e9lulas que cont\u00eam valores est\u00e1ticos de c\u00e9lulas que cont\u00eam f\u00f3rmulas, facilitando assim a depura\u00e7\u00e3o e manuten\u00e7\u00e3o dos dados. O retorno dessa fun\u00e7\u00e3o \u00e9 bin\u00e1rio, ou seja, ela retorna VERDADEIRO se a c\u00e9lula examinada contiver uma f\u00f3rmula, e FALSO, caso contr\u00e1rio.<\/p>\n<h2>Sintaxe e Exemplos B\u00e1sicos<\/h2>\n<p>A sintaxe da fun\u00e7\u00e3o \u00e9 simples:<\/p>\n<pre><code>ISFORMULA(c\u00e9lula)<\/code><\/pre>\n<p>O termo &#8220;c\u00e9lula&#8221; refere-se \u00e0 refer\u00eancia da c\u00e9lula que queremos verificar. Por exemplo:<\/p>\n<pre><code>Considere a c\u00e9lula A1 com a f\u00f3rmula =B1+C1. Ao aplicar ISFORMULA em A1: =ISFORMULA(A1) O resultado ser\u00e1 VERDADEIRO, pois A1 cont\u00e9m uma f\u00f3rmula. Se B1 contiver um valor est\u00e1tico: =ISFORMULA(B1) O resultado ser\u00e1 FALSO.<\/code><\/pre>\n<h2>Aplica\u00e7\u00f5es Pr\u00e1ticas da Fun\u00e7\u00e3o<\/h2>\n<ul>\n<li><strong>Auditoria de Planilhas:<\/strong> Identificar c\u00e9lulas que cont\u00eam f\u00f3rmulas \u00e9 crucial em auditorias de planilhas complexas, permitindo revis\u00f5es focadas nos c\u00e1lculos e l\u00f3gicas aplicadas.<\/li>\n<li><strong>Documenta\u00e7\u00e3o Din\u00e2mica:<\/strong> Utilizar o \u00c9.FORMULA para mapear ou indexar c\u00e9lulas que cont\u00eam f\u00f3rmulas pode simplificar a documenta\u00e7\u00e3o e o treinamento, melhorando a compreens\u00e3o da estrutura da planilha.<\/li>\n<\/ul>\n<h2>Exemplo Pr\u00e1tico 1: Auditoria com Destaque em F\u00f3rmulas<\/h2>\n<p>Para destacar todas as c\u00e9lulas que cont\u00eam f\u00f3rmulas em um intervalo espec\u00edfico, facilitando a revis\u00e3o da planilha, siga os passos abaixo:<\/p>\n<pre><code>1. Selecione o intervalo desejado. 2. Aplique uma formata\u00e7\u00e3o condicional com a f\u00f3rmula =ISFORMULA(A1) para a c\u00e9lula A1 e expanda para as outras c\u00e9lulas no intervalo. 3. Configure a formata\u00e7\u00e3o para destacar as c\u00e9lulas que retornem VERDADEIRO.<\/code><\/pre>\n<p>Este processo melhora a visibilidade das f\u00f3rmulas e torna a revis\u00e3o mais direta e eficiente.<\/p>\n<h2>Exemplo Pr\u00e1tico 2: Criando um Relat\u00f3rio de F\u00f3rmulas<\/h2>\n<p>Para criar um relat\u00f3rio que identifique as c\u00e9lulas de uma planilha que cont\u00eam f\u00f3rmulas:<\/p>\n<pre><code>1. Inicie uma nova coluna ao lado dos seus dados. 2. Digite a f\u00f3rmula =SE(ISFORMULA(A1), \"Cont\u00e9m F\u00f3rmula\", \"Sem F\u00f3rmula\"). 3. Copie essa f\u00f3rmula para as outras c\u00e9lulas da coluna, criando uma lista que indica claramente a presen\u00e7a de f\u00f3rmulas.<\/code><\/pre>\n<p>Este tipo de relat\u00f3rio \u00e9 extremamente valioso em processos de documenta\u00e7\u00e3o e na transfer\u00eancia de planilhas entre usu\u00e1rios, facilitando a compreens\u00e3o das fun\u00e7\u00f5es desempenhadas na planilha.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devolve VERDADEIRO se existir uma refer\u00eancia a uma c\u00e9lula que contenha uma f\u00f3rmula<\/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-10972","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 ISFORMULA (\u00c9.FORMULA) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) 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\/isformula\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/isformula\/\" \/>\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:38+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 ISFORMULA (\u00c9.FORMULA) 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\/isformula\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/isformula\/\",\"name\":\"Fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) 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:38+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/isformula\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/isformula\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/isformula\/#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.FORMULA\"}]},{\"@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 ISFORMULA (\u00c9.FORMULA) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) 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\/isformula\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/isformula\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:22:38+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) 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\/isformula\/","url":"https:\/\/functiontranslator.com\/pt-pt\/isformula\/","name":"Fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) 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:38+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ISFORMULA (\u00c9.FORMULA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/isformula\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/isformula\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/isformula\/#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.FORMULA"}]},{"@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\/10972","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=10972"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10972\/revisions"}],"predecessor-version":[{"id":25801,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10972\/revisions\/25801"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}