{"id":14070,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/log\/"},"modified":"2021-02-26T08:53:16","modified_gmt":"2021-02-26T08:53:16","slug":"log","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/log\/","title":{"rendered":"LOG"},"content":{"rendered":"

Descripci\u00f3n y Sintaxis de la Funci\u00f3n Logar\u00edtmica<\/h2>\n

La funci\u00f3n logar\u00edtmica, denominada LOG<\/code> tanto en Microsoft Excel como en Google Sheets, se emplea para calcular el logaritmo de un n\u00famero con una base determinada. Esta funci\u00f3n es extremadamente \u00fatil para el an\u00e1lisis en campos como el financiero, el cient\u00edfico y el estad\u00edstico.<\/p>\n

Sintaxis en Excel:<\/strong><\/p>\n

LOG(n\u00famero, [base])<\/code><\/pre>\n
    \n
  • n\u00famero<\/strong> – El n\u00famero del cual se calcular\u00e1 el logaritmo. Debe ser positivo.<\/li>\n
  • base<\/strong> – La base del logaritmo. Si no se especifica, Excel utiliza la base 10 por defecto.<\/li>\n<\/ul>\n
    Sintaxis en Google Sheets:<\/strong><\/p>\n
    LOG(number, [base])<\/code><\/pre>\n
      \n
    • number<\/strong> – El n\u00famero del cual se calcular\u00e1 el logaritmo. Debe ser positivo.<\/li>\n
    • base<\/strong> – La base del logaritmo. Si se omite, Google Sheets utiliza la base 10 por defecto.<\/li>\n<\/ul>\n
      Ejemplo de Uso:<\/strong><\/p>\n
      =LOG(100) \/\/ Devuelve 2 porque el logaritmo base 10 de 100 es 2. =LOG(8, 2) \/\/ Devuelve 3 porque el logaritmo base 2 de 8 es 3.<\/code><\/pre>\n
      Aplicaciones Pr\u00e1cticas de la Funci\u00f3n<\/h2>\n
      La funci\u00f3n logar\u00edtmica es vers\u00e1til y puede ser aplicada en varios contextos pr\u00e1cticos. A continuaci\u00f3n, se presentan dos ejemplos concretos:<\/p>\n
      Analizando el Crecimiento Exponencial<\/h2>\n
      Consideremos una poblaci\u00f3n de bacterias que se duplica cada hora. Si partimos de una sola bacteria, \u00bfcu\u00e1nto tiempo tardar\u00e1 en alcanzar al menos 1,000 bacterias?<\/p>\n
      =LOG(1000, 2)<\/code><\/pre>\n
      Respuesta: Utilizando la funci\u00f3n con base 2, encontramos que se necesitar\u00e1n aproximadamente 10 horas para alcanzar o superar una poblaci\u00f3n de 1,000 bacterias.<\/p>\n
      Calculando el Tiempo de Desintegraci\u00f3n<\/h2>\n
      El Carbono-14 tiene una vida media de aproximadamente 5730 a\u00f1os. Si deseamos determinar cu\u00e1ntos a\u00f1os deben transcurrir para que solo reste el 1% del Carbono-14 original en una muestra, podemos usar la siguiente f\u00f3rmula:<\/p>\n
      =LOG(0.01, 0.5) * 5730<\/code><\/pre>\n
      Este c\u00e1lculo emplea el logaritmo base 0.5, adecuado para procesos de desintegraci\u00f3n a la mitad, y multiplica el resultado por la vida media del Carbono-14 para obtener el tiempo necesario.<\/p>\n
      Respuesta: Se necesitan aproximadamente 39,098 a\u00f1os para que solamente quede el 1% del Carbono-14 original.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve el logaritmo de un n\u00famero en una 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":[535],"tags":[],"class_list":["post-14070","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LOG de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/log\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LOG de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/log\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:53:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\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\/es\/log\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/log\/\",\"name\":\"Funci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:53:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n LOG de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/log\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/log\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/log\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1ticas y trigonometr\u00eda\",\"item\":\"https:\/\/functiontranslator.com\/es\/matematicas-y-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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n LOG de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/log\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n LOG de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/log\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:53:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/log\/","url":"https:\/\/functiontranslator.com\/es\/log\/","name":"Funci\u00f3n LOG en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:53:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n LOG de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/log\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/log\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/log\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1ticas y trigonometr\u00eda","item":"https:\/\/functiontranslator.com\/es\/matematicas-y-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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14070"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14070\/revisions"}],"predecessor-version":[{"id":30163,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14070\/revisions\/30163"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}