{"id":10776,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/cel\/"},"modified":"2021-02-25T17:15:02","modified_gmt":"2021-02-25T17:15:02","slug":"cell","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/cell\/","title":{"rendered":"C\u00c9L"},"content":{"rendered":"<p>A fun\u00e7\u00e3o CELL no Excel ou C\u00c9L nas Planilhas Google \u00e9 utilizada para extrair informa\u00e7\u00f5es sobre formata\u00e7\u00e3o, localiza\u00e7\u00e3o ou conte\u00fado de uma c\u00e9lula. Esta fun\u00e7\u00e3o \u00e9 especialmente \u00fatil em contextos que exigem um detalhamento das propriedades das c\u00e9lulas em uma planilha.<\/p>\n<h2>Descri\u00e7\u00e3o e Sintaxe<\/h2>\n<p>A fun\u00e7\u00e3o \u00e9 definida pela seguinte sintaxe:<\/p>\n<ul>\n<li><strong>Excel:<\/strong> <code>CELL(info_type, [reference])<\/code><\/li>\n<li><strong>Planilhas Google:<\/strong> <code>C\u00c9L(tipo_de_info, [refer\u00eancia])<\/code><\/li>\n<\/ul>\n<p>Onde:<\/p>\n<ul>\n<li><strong>info_type:<\/strong> Um texto que especifica o tipo de informa\u00e7\u00e3o desejada, como &#8220;address&#8221; para endere\u00e7o da c\u00e9lula ou &#8220;format&#8221; para formato da c\u00e9lula.<\/li>\n<li><strong>reference:<\/strong> Refere-se \u00e0 c\u00e9lula ou ao intervalo de c\u00e9lulas que ser\u00e1 investigado. Se omitido, a fun\u00e7\u00e3o considerar\u00e1 a c\u00e9lula na qual est\u00e1 sendo aplicada.<\/li>\n<\/ul>\n<h2>Exemplos de Uso<\/h2>\n<pre> <code>Para obter o endere\u00e7o de uma c\u00e9lula D5: =CELL(\"address\", D5) --> Retorna \"$D$5\" no Excel ou C\u00c9L(\"endere\u00e7o\", D5) --> Retorna \"$D$5\" nas Planilhas Google. Para identificar o formato num\u00e9rico de uma c\u00e9lula B3: =CELL(\"format\", B3) --> Pode retornar \"F2\" se formatado como decimal no Excel. <\/code> <\/pre>\n<h2>Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n<p><strong>Caso 1: Verifica\u00e7\u00e3o da Formata\u00e7\u00e3o de C\u00e9lulas para Relat\u00f3rios<\/strong><\/p>\n<table>\n<tr>\n<th>Problema<\/th>\n<td>Verificar se as c\u00e9lulas em uma coluna de pre\u00e7os est\u00e3o corretamente formatadas como valor monet\u00e1rio.<\/td>\n<\/tr>\n<tr>\n<th>Solu\u00e7\u00e3o<\/th>\n<td>Utilize a fun\u00e7\u00e3o CELL para examinar o formato de cada c\u00e9lula e configure uma resposta condicional conforme a necessidade.<\/td>\n<\/tr>\n<\/table>\n<pre> <code>Exemplo no Excel: Se a c\u00e9lula A2 deve estar no formato monet\u00e1rio, teste com: =IF(CELL(\"format\", A2) = \"C2\", \"Correto\", \"Verificar Formata\u00e7\u00e3o\") No Google Sheets: Se a c\u00e9lula A2 deve estar no formato monet\u00e1rio, teste com: =IF(C\u00c9L(\"formato\", A2) = \"Moeda\", \"Correto\", \"Verificar Formata\u00e7\u00e3o\") <\/code> <\/pre>\n<p><strong>Caso 2: Monitoramento de Refer\u00eancias de C\u00e9lulas<\/strong><\/p>\n<table>\n<tr>\n<th>Problema<\/th>\n<td>Monitorar se c\u00e9lulas espec\u00edficas est\u00e3o se referindo \u00e0s c\u00e9lulas corretas em f\u00f3rmulas complexas.<\/td>\n<\/tr>\n<tr>\n<th>Solu\u00e7\u00e3o<\/th>\n<td>Use a fun\u00e7\u00e3o CELL para identificar o endere\u00e7o referenciado por f\u00f3rmulas em outras c\u00e9lulas, garantindo assim que a refer\u00eancia est\u00e1 correta.<\/td>\n<\/tr>\n<\/table>\n<pre> <code>Exemplo no Excel: Suponha que a c\u00e9lula F5 deva referenciar a c\u00e9lula B3: =IF(CELL(\"address\", INDIRECT(\"F5\")) = \"$B$3\", \"Correto\", \"Corrigir Refer\u00eancia\") Na Planilhas Google seria similar: =IF(C\u00c9L(\"endere\u00e7o\", INDIRECT(\"F5\")) = \"$B$3\", \"Correto\", \"Corrigir Refer\u00eancia\") <\/code> <\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Devolve informa\u00e7\u00f5es sobre a formata\u00e7\u00e3o, localiza\u00e7\u00e3o ou conte\u00fado de uma c\u00e9lula<\/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-10776","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 CELL (C\u00c9L) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CELL (C\u00c9L) 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\/cell\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o CELL (C\u00c9L) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CELL (C\u00c9L) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/cell\/\" \/>\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:15:02+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 CELL (C\u00c9L) 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\/cell\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/cell\/\",\"name\":\"Fun\u00e7\u00e3o CELL (C\u00c9L) 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:15:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CELL (C\u00c9L) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/cell\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/cell\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/cell\/#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\":\"C\u00c9L\"}]},{\"@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 CELL (C\u00c9L) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CELL (C\u00c9L) 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\/cell\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o CELL (C\u00c9L) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CELL (C\u00c9L) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/cell\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:15:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o CELL (C\u00c9L) 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\/cell\/","url":"https:\/\/functiontranslator.com\/pt-pt\/cell\/","name":"Fun\u00e7\u00e3o CELL (C\u00c9L) 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:15:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CELL (C\u00c9L) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/cell\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/cell\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/cell\/#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":"C\u00c9L"}]},{"@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\/10776","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=10776"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10776\/revisions"}],"predecessor-version":[{"id":25605,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10776\/revisions\/25605"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}