{"id":14069,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/ln\/"},"modified":"2021-02-26T08:53:15","modified_gmt":"2021-02-26T08:53:15","slug":"ln","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/ln\/","title":{"rendered":"LN"},"content":{"rendered":"<h2>Introducci\u00f3n<\/h2>\n<p>La funci\u00f3n LN en Excel y Google Sheets se utiliza para calcular el logaritmo natural de un n\u00famero. Este logaritmo se basa en el n\u00famero e (aproximadamente 2.71828182845904), que es la base de los logaritmos naturales.<\/p>\n<h2>Sintaxis y Ejemplo<\/h2>\n<p>La sintaxis para la funci\u00f3n LN es la siguiente:<\/p>\n<pre><code>LN(n\u00famero)<\/code><\/pre>\n<p>En esta funci\u00f3n, <code>n\u00famero<\/code> representa el valor del cual deseas obtener el logaritmo natural. Es necesario que el n\u00famero sea positivo.<\/p>\n<p>Ejemplo:<\/p>\n<pre><code>=LN(10)<\/code><\/pre>\n<p>Este ejemplo calcula el logaritmo natural de 10.<\/p>\n<h2>Aplicaciones pr\u00e1cticas<\/h2>\n<p>El c\u00e1lculo de logaritmos naturales tiene m\u00faltiples usos en diferentes campos de las matem\u00e1ticas y la ciencia, como el an\u00e1lisis del crecimiento exponencial y la descomposici\u00f3n en series de tiempo.<\/p>\n<h2>Problema 1: Crecimiento Exponencial<\/h2>\n<p>Considera que est\u00e1s evaluando el crecimiento de una poblaci\u00f3n de bacterias que se multiplica de forma exponencial. La poblaci\u00f3n inicial es de 500 bacterias, duplic\u00e1ndose cada hora. \u00bfCu\u00e1nto tiempo tardar\u00e1 en alcanzar una poblaci\u00f3n de 8000 bacterias?<\/p>\n<p>Soluci\u00f3n:<\/p>\n<pre><code>1. Aplica la f\u00f3rmula de crecimiento exponencial: P = Pe^(rt) Donde: P = poblaci\u00f3n final Pe = poblaci\u00f3n inicial r = tasa de crecimiento t = tiempo (en horas) 2. Reorganiza la f\u00f3rmula para despejar t (tiempo): t = ln(P\/Pe) \/ r 3. Calcula r considerando que la poblaci\u00f3n se duplica cada hora: r = ln(2) \/ 1 = 0.6931 4. Sustituye en la f\u00f3rmula: t = ln(8000 \/ 500) \/ 0.6931 = 4.16 horas<\/code><\/pre>\n<p>Por lo tanto, se necesitar\u00e1n aproximadamente 4.16 horas para que la poblaci\u00f3n alcance los 8000 individuos.<\/p>\n<h2>Problema 2: Depreciaci\u00f3n de activos<\/h2>\n<p>Esta funci\u00f3n tambi\u00e9n es \u00fatil para calcular cu\u00e1nto tiempo tardar\u00e1 un activo en perder la mitad de su valor inicial bajo un modelo de depreciaci\u00f3n continua.<\/p>\n<p>Soluci\u00f3n:<\/p>\n<pre><code>1. Supongamos que el valor inicial del activo es V0 y se deprecia a una tasa r constante. 2. La f\u00f3rmula de depreciaci\u00f3n continua es: V = V0 * e^(-rt) 3. Para determinar el tiempo cuando el activo vale la mitad de V0: V = V0 \/ 2 4. Reorganiza la f\u00f3rmula para resolver para t: t = ln(2) \/ r 5. Si r = 0.1 (asumiendo una tasa anual): t = ln(2) \/ 0.1 = 6.931 a\u00f1os<\/code><\/pre>\n<p>Por lo tanto, el activo tardar\u00e1 aproximadamente 6.931 a\u00f1os en depreciarse hasta la mitad de su valor original.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devuelve el logaritmo natural de un n\u00famero<\/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-14069","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n LN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LN 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\/ln\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n LN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/ln\/\" \/>\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:15+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 LN 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\/ln\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/ln\/\",\"name\":\"Funci\u00f3n LN 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:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n LN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/ln\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/ln\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/ln\/#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\":\"LN\"}]},{\"@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 LN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n LN 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\/ln\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n LN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n LN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/ln\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:53:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n LN 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\/ln\/","url":"https:\/\/functiontranslator.com\/es\/ln\/","name":"Funci\u00f3n LN 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:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n LN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/ln\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/ln\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/ln\/#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":"LN"}]},{"@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\/14069","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=14069"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14069\/revisions"}],"predecessor-version":[{"id":30162,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14069\/revisions\/30162"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}