{"id":10989,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/funcao\/"},"modified":"2021-02-26T18:47:25","modified_gmt":"2021-02-26T18:47:25","slug":"let","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/let\/","title":{"rendered":"LET"},"content":{"rendered":"

A fun\u00e7\u00e3o LET do Excel \u00e9 incrivelmente \u00fatil para simplificar f\u00f3rmulas complexas que repetem certos c\u00e1lculos m\u00faltiplas vezes. Essa fun\u00e7\u00e3o permite que voc\u00ea defina vari\u00e1veis dentro de uma f\u00f3rmula, armazenando um valor ou o resultado de um c\u00e1lculo sob um nome de sua escolha, o que n\u00e3o s\u00f3 facilita a leitura da f\u00f3rmula, mas tamb\u00e9m pode aprimorar o desempenho ao diminuir o n\u00famero de c\u00e1lculos repetidos que o Excel precisa realizar.<\/p>\n

Como a Fun\u00e7\u00e3o LET \u00e9 Estruturada?<\/h2>\n

No Excel, voc\u00ea pode definir e utilizar vari\u00e1veis locais dentro de suas f\u00f3rmulas. A sintaxe da fun\u00e7\u00e3o LET \u00e9 a seguinte:<\/p>\n

 LET(nome1, nome_valor1, [nome2, nome_valor2, ...], c\u00e1lculo)<\/code> <\/pre>\n
    \n
  • nome1, nome2, …<\/strong> s\u00e3o os nomes que voc\u00ea atribui aos valores ou f\u00f3rmulas.<\/li>\n
  • nome_valor1, nome_valor2, …<\/strong> s\u00e3o os valores ou f\u00f3rmulas que esses nomes representam.<\/li>\n
  • c\u00e1lculo<\/strong> \u00e9 a express\u00e3o final que faz uso dessas vari\u00e1veis.<\/li>\n<\/ul>\n
    Exemplo pr\u00e1tico:<\/p>\n
     =LET(x, 5, x * x) # Resultado ser\u00e1 25<\/code> <\/pre>\n
    Exemplos Pr\u00e1ticos e Aplica\u00e7\u00f5es<\/h2>\n
    Vejamos algumas aplica\u00e7\u00f5es pr\u00e1ticas da fun\u00e7\u00e3o LET para demonstrar como ela pode ser eficaz em situa\u00e7\u00f5es do dia a dia.<\/p>\n
    C\u00e1lculo de M\u00e9dia Ponderada<\/h2>\n
    Considere o c\u00e1lculo da m\u00e9dia ponderada das notas de um aluno, considerando pesos diferentes para cada avalia\u00e7\u00e3o:<\/p>\n\n\n\n\n\n
    Nota<\/th>\nPeso<\/th>\n<\/tr>\n
    7<\/td>\n3<\/td>\n<\/tr>\n
    9<\/td>\n4<\/td>\n<\/tr>\n
    8<\/td>\n2<\/td>\n<\/tr>\n<\/table>\n
     =LET(n1, 7, p1, 3, n2, 9, p2, 4, n3, 8, p3, 2, (n1 * p1 + n2 * p2 + n3 * p3) \/ (p1 + p2 + p3)) # Resultado: 8.111<\/code> <\/pre>\n
    Aqui, n1<\/em>, p1<\/em>, n2<\/em>, p2<\/em>, n3<\/em>, p3<\/em> s\u00e3o vari\u00e1veis para notas e pesos, respectivamente, simplificando a f\u00f3rmula e aumentando sua legibilidade.<\/p>\n
    Otimiza\u00e7\u00e3o de C\u00e1lculos em Dados Financeiros<\/h2>\n
    Imagine que voc\u00ea queira calcular o valor futuro de um investimento usando v\u00e1rias vari\u00e1veis que se repetem na f\u00f3rmula.<\/p>\n
     =LET(capital, 1000, taxa, 0.05, tempo, 10, capital * (1 + taxa) ^ tempo) # Resultado: 1628.89<\/code> <\/pre>\n
    Este exemplo calcula o valor futuro de um investimento inicial de 1000 unidades monet\u00e1rias \u00e0 taxa de 5% ao ano por um per\u00edodo de 10 anos. O uso da fun\u00e7\u00e3o LET torna a f\u00f3rmula mais clara e reduz a necessidade de repetir as mesmas opera\u00e7\u00f5es matem\u00e1ticas.<\/p>\n
    Em resumo, a fun\u00e7\u00e3o LET \u00e9 extremamente valiosa para otimizar f\u00f3rmulas extensas e para melhorar a legibilidade e efici\u00eancia de suas planilhas, simplificando a manuten\u00e7\u00e3o e compreens\u00e3o dos c\u00e1lculos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Atribui nomes aos resultados de c\u00e1lculo para permitir o armazenamento de c\u00e1lculos interm\u00e9dios, valores ou defini\u00e7\u00e3o de nomes dentro de 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":[437],"tags":[],"class_list":["post-10989","post","type-post","status-publish","format-standard","hentry","category-matematica-e-trigonometria"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o LET no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LET 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\/let\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o LET no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LET do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/let\/\" \/>\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-26T18:47:25+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 LET 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\/let\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/let\/\",\"name\":\"Fun\u00e7\u00e3o LET 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-26T18:47:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LET do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/let\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/let\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/let\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1tica e trigonometria\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LET\"}]},{\"@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 LET no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LET 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\/let\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o LET no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LET do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/let\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-26T18:47:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o LET 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\/let\/","url":"https:\/\/functiontranslator.com\/pt-pt\/let\/","name":"Fun\u00e7\u00e3o LET 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-26T18:47:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LET do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/let\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/let\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/let\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1tica e trigonometria","item":"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/"},{"@type":"ListItem","position":3,"name":"LET"}]},{"@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\/10989","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=10989"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10989\/revisions"}],"predecessor-version":[{"id":32012,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10989\/revisions\/32012"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}