{"id":10992,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/log\/"},"modified":"2021-02-25T17:23:39","modified_gmt":"2021-02-25T17:23:39","slug":"log","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/log\/","title":{"rendered":"LOG"},"content":{"rendered":"<h2>Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o Logaritmo<\/h2>\n<p>No Microsoft Excel e no Google Planilhas, a fun\u00e7\u00e3o logar\u00edtmica \u00e9 uma ferramenta extremamente \u00fatil para calcular o logaritmo de um n\u00famero de acordo com uma base espec\u00edfica. Essa fun\u00e7\u00e3o \u00e9 amplamente aplicada em \u00e1reas como matem\u00e1tica, ci\u00eancia, engenharia e an\u00e1lise financeira.<\/p>\n<h2>Sintaxe e Exemplos<\/h2>\n<p>A fun\u00e7\u00e3o logaritmo possui uma sintaxe que varia ligeiramente entre o Excel e o Google Planilhas:<\/p>\n<ul>\n<li><strong>Excel:<\/strong> <code>LOG(n\u00famero, base)<\/code><\/li>\n<li><strong>Google Planilhas:<\/strong> <code>LOG10(n\u00famero, base)<\/code><\/li>\n<\/ul>\n<p>Para utilizar a fun\u00e7\u00e3o, voc\u00ea precisa dos seguintes argumentos:<\/p>\n<ul>\n<li><strong>n\u00famero<\/strong> &#8211; O valor para o qual deseja calcular o logaritmo.<\/li>\n<li><strong>base<\/strong> &#8211; A base do logaritmo. Se omisso, o padr\u00e3o ser\u00e1 10.<\/li>\n<\/ul>\n<p><strong>Exemplo 1:<\/strong> Para calcular o logaritmo de 100 na base 10:<\/p>\n<pre><code>=LOG(100, 10)<\/code><\/pre>\n<p>Este exemplo retorna 2, visto que 10^2 = 100.<\/p>\n<p><strong>Exemplo 2:<\/strong> No Google Planilhas, calcule o logaritmo de 32 na base 2:<\/p>\n<pre><code>=LOG10(32, 2)<\/code><\/pre>\n<p>O resultado ser\u00e1 5, pois 2^5 = 32.<\/p>\n<h2>Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n<h3>Situa\u00e7\u00e3o 1: An\u00e1lise de Decaimento Exponencial<\/h3>\n<p>Usada com frequ\u00eancia nas ci\u00eancias para analisar decaimentos ou diminui\u00e7\u00f5es exponenciais ao longo do tempo, a fun\u00e7\u00e3o logaritmo auxilia na determina\u00e7\u00e3o das taxas de decaimento.<\/p>\n<pre><code>Valor inicial = 1000 Tempo (dias) = 50 Taxa = 0.03 Valor final = Valor inicial * EXP(-Taxa * Tempo) Log do Valor final = LOG10(Valor final; e)<\/code><\/pre>\n<p>Essas f\u00f3rmulas s\u00e3o valiosas para entender as taxas de decaimento em processos qu\u00edmicos e biol\u00f3gicos.<\/p>\n<h3>Situa\u00e7\u00e3o 2: C\u00e1lculo de Per\u00edodos de Amortiza\u00e7\u00e3o<\/h3>\n<p>Calcular o tempo necess\u00e1rio para quitar um empr\u00e9stimo com juros compostos \u00e9 outra aplica\u00e7\u00e3o pr\u00e1tica do logaritmo. Se voc\u00ea deseja saber os anos necess\u00e1rios para pagar completamente um empr\u00e9stimo com base no montante principal, taxa de juros anual e pagamento anual, a fun\u00e7\u00e3o logaritmo \u00e9 essencial.<\/p>\n<pre><code>Principal = 20000 Taxa de juros anual = 0.05 Pagamento anual = 3000 N = LOG10(Principal \/ (Principal - Pagamento anual * (1 + Taxa de juros anual)), 1 + Taxa de juros anual)<\/code><\/pre>\n<p>Este exemplo oferece uma estimativa do n\u00famero de anos necess\u00e1rios para amortizar por completo o empr\u00e9stimo.<\/p>\n<p>As fun\u00e7\u00f5es logar\u00edtmicas no Excel e no Google Planilhas simplificam a realiza\u00e7\u00e3o de c\u00e1lculos complexos, tornando-se ferramentas importantes no cen\u00e1rio profissional e acad\u00eamico.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devolve o logaritmo de um n\u00famero com uma base especificada<\/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-10992","post","type-post","status-publish","format-standard","hentry","category-matematica-e-trigonometria"],"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 LOG no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LOG 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\/log\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o LOG no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LOG do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/log\/\" \/>\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:23:39+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 LOG 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\/log\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/log\/\",\"name\":\"Fun\u00e7\u00e3o LOG 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:23:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LOG do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/log\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/log\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/log\/#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\":\"LOG\"}]},{\"@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 LOG no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LOG 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\/log\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o LOG no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LOG do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/log\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:23:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o LOG 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\/log\/","url":"https:\/\/functiontranslator.com\/pt-pt\/log\/","name":"Fun\u00e7\u00e3o LOG 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:23:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LOG do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/log\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/log\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/log\/#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":"LOG"}]},{"@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\/10992","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=10992"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10992\/revisions"}],"predecessor-version":[{"id":25821,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10992\/revisions\/25821"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}