{"id":14024,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/im-ln\/"},"modified":"2021-02-26T08:51:02","modified_gmt":"2021-02-26T08:51:02","slug":"imln","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/imln\/","title":{"rendered":"IM.LN"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

En Microsoft Excel y Google Sheets, la funci\u00f3n IMLN (o simplemente LN en Google Sheets) se utiliza para calcular el logaritmo natural de un n\u00famero. El logaritmo natural corresponde al logaritmo con base e, donde e es una constante matem\u00e1tica aproximada en 2.71828.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n es la siguiente:<\/p>\n

IMLN(n\u00famero)<\/code><\/pre>\n
El argumento n\u00famero<\/code> puede ser un valor num\u00e9rico directo, una referencia a una celda que contenga un n\u00famero, o una f\u00f3rmula que resulte en un n\u00famero.<\/p>\n
Ejemplo 1: Calcular el logaritmo natural de 10.<\/p>\n
=IMLN(10)<\/code><\/pre>\n
Este ejemplo devolver\u00e1 2.302585, que es el logaritmo natural de 10.<\/p>\n
Ejemplo 2: Uso de IMLN con referencia a celda:<\/p>\n
Supongamos que A1 contiene el n\u00famero 20. F\u00f3rmula: =IMLN(A1)<\/code><\/pre>\n
Esto calcular\u00e1 el logaritmo natural del n\u00famero en la celda A1 (20), devolviendo 2.995732.<\/p>\n
Aplicaciones Pr\u00e1cticas<\/h2>\n
El logaritmo natural se puede utilizar en diversos contextos pr\u00e1cticos, especialmente en las disciplinas de ciencias, finanzas y an\u00e1lisis de datos.<\/p>\n
An\u00e1lisis de Crecimiento Exponencial<\/h2>\n
En la modelaci\u00f3n de crecimientos, como los de poblaciones o inter\u00e9s compuesto, el logaritmo natural es \u00fatil para determinar tasas de crecimiento subyacentes.<\/p>\n
Supongamos que el tama\u00f1o final de una poblaci\u00f3n es de 10,000 individuos y el inicial de 1,000. Si el crecimiento sigue un modelo exponencial, podemos aplicar: =IMLN(10,000 \/ 1,000)<\/code><\/pre>\n
Esto proporcionar\u00e1 una estimaci\u00f3n de la tasa de crecimiento en el modelo.<\/p>\n
Decaimiento Exponencial en F\u00edsica y Qu\u00edmica<\/h2>\n
De manera similar al crecimiento, el decaimiento (como el radioactivo) tambi\u00e9n puede modelarse con ecuaciones exponenciales. IMLN es \u00fatil para analizar estos procesos.<\/p>\n
Si una sustancia radioactiva decae de 1000 unidades a 100 en un periodo determinado: F\u00f3rmula: =IMLN(100 \/ 1,000)<\/code><\/pre>\n
Este c\u00e1lculo proporcionar\u00e1 una medida del decaimiento exponencial experimentado por la sustancia.<\/p>\n
Conclusiones<\/h2>\n
La funci\u00f3n IMLN es una herramienta fundamental en Excel y Google Sheets, facilitando el c\u00e1lculo de logaritmos naturales que son esenciales en una amplia gama de aplicaciones matem\u00e1ticas y cient\u00edficas.<\/p>\n","protected":false},"excerpt":{"rendered":"
Devuelve el logaritmo natural (neperiano) de un n\u00famero complejo<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[541],"tags":[],"class_list":["post-14024","post","type-post","status-publish","format-standard","hentry","category-ingenieria"],"acf":[],"yoast_head":"\nFunci\u00f3n IMLN (IM.LN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMLN (IM.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\/imln\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n IMLN (IM.LN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMLN (IM.LN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/imln\/\" \/>\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:51:02+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 IMLN (IM.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\/imln\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/imln\/\",\"name\":\"Funci\u00f3n IMLN (IM.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:51:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n IMLN (IM.LN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/imln\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/imln\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/imln\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ingenier\u00eda\",\"item\":\"https:\/\/functiontranslator.com\/es\/ingenieria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"IM.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 IMLN (IM.LN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n IMLN (IM.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\/imln\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n IMLN (IM.LN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n IMLN (IM.LN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/imln\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:51:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n IMLN (IM.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\/imln\/","url":"https:\/\/functiontranslator.com\/es\/imln\/","name":"Funci\u00f3n IMLN (IM.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:51:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n IMLN (IM.LN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/imln\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/imln\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/imln\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Ingenier\u00eda","item":"https:\/\/functiontranslator.com\/es\/ingenieria\/"},{"@type":"ListItem","position":3,"name":"IM.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\/14024","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=14024"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14024\/revisions"}],"predecessor-version":[{"id":30079,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14024\/revisions\/30079"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}