{"id":14014,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/imaginario\/"},"modified":"2021-02-26T08:50:09","modified_gmt":"2021-02-26T08:50:09","slug":"imaginary","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/imaginary\/","title":{"rendered":"IMAGINARIO"},"content":{"rendered":"

La funci\u00f3n IMAGINARIO en Excel y Google Sheets se utiliza para extraer la parte imaginaria de un n\u00famero complejo, el cual se representa como texto. Un n\u00famero complejo incluye una parte real e imaginaria; esta funci\u00f3n se especializa en aislar \u00fanicamente la componente imaginaria.<\/p>\n

Sintaxis y ejemplos b\u00e1sicos<\/h2>\n

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

=IMAGINARIO(n\u00famero_complejo)<\/code><\/pre>\n
    \n
  • n\u00famero_complejo<\/strong>: Es el n\u00famero complejo del cual deseas obtener la parte imaginaria. Este debe estar en formato de texto, por ejemplo, \u00ab3+4i\u00bb o \u00ab3-4i\u00bb.<\/li>\n<\/ul>\n
    Ejemplo:<\/p>\n\n\n\n\n
    F\u00f3rmula<\/th>\nResultado<\/th>\nExplicaci\u00f3n<\/th>\n<\/tr>\n
    =IMAGINARIO(\"3+4i\")<\/code><\/td>\n4<\/td>\nExtrae la parte imaginaria del n\u00famero complejo (4).<\/td>\n<\/tr>\n
    =IMAGINARIO(\"3-4i\")<\/code><\/td>\n-4<\/td>\nExtrae la parte imaginaria del n\u00famero complejo (-4).<\/td>\n<\/tr>\n<\/table>\n
    Aplicaciones pr\u00e1cticas<\/h2>\n
    An\u00e1lisis de se\u00f1ales el\u00e9ctricas<\/h2>\n
    Imagina que trabajas con se\u00f1ales el\u00e9ctricas presentadas en forma compleja para realizar un an\u00e1lisis de frecuencia, que incluye tanto partes reales como imaginarias. Para ciertos an\u00e1lisis espec\u00edficos, necesitar\u00edas extraer \u00fanicamente las partes imaginarias de estas se\u00f1ales:<\/p>\n
    =IMAGINARIO(A2)<\/code><\/pre>\n
    Donde A2<\/em> contiene \u00ab2+5i\u00bb; el resultado ser\u00eda 5. Si tienes una lista de n\u00fameros complejos en el rango A2:A10, aplicar esta funci\u00f3n a cada uno de ellos resultar\u00e1 \u00fatil para abordar transformadas de Fourier u otros an\u00e1lisis similares.<\/p>\n
    Impedancia en circuitos el\u00e9ctricos<\/h2>\n
    En ingenier\u00eda el\u00e9ctrica, describir la impedancia de un circuito a menudo implica utilizar n\u00fameros complejos. La parte imaginaria es esencial para comprender el comportamiento reactivo del circuito. Sup\u00f3n que cuentas con varias mediciones de impedancia y necesitas identificar \u00fanicamente sus componentes reactivos (imaginarios):<\/p>\n
    =IMAGINARIO(B2)<\/code><\/pre>\n
    Si B2<\/em> contiene \u00ab50+30i\u00bb ohms, el resultado ser\u00eda 30, lo que refleja la magnitud de la resistencia reactiva y proporciona informaci\u00f3n crucial sobre c\u00f3mo el circuito almacenar\u00e1 energ\u00eda temporalmente. Al realizar este c\u00e1lculo en un conjunto de datos, como en el rango B2:B100, puedes analizar c\u00f3mo var\u00eda la reactancia en diferentes circuitos o condiciones experimentales, lo cual es fundamental para el dise\u00f1o y an\u00e1lisis de sistemas de circuitos.<\/p>\n
    As\u00ed, la funci\u00f3n IMAGINARIO se revela como una herramienta indispensable en \u00e1reas como la ingenier\u00eda el\u00e9ctrica y los sistemas de control, donde los n\u00fameros complejos son frecuentemente usados para describir fen\u00f3menos en dominios de tiempo y frecuencia.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el coeficiente imaginario 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-14014","post","type-post","status-publish","format-standard","hentry","category-ingenieria"],"acf":[],"yoast_head":"\nFunci\u00f3n IMAGINARY (IMAGINARIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMAGINARY (IMAGINARIO) 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\/imaginary\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n IMAGINARY (IMAGINARIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMAGINARY (IMAGINARIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/imaginary\/\" \/>\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:50:09+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 IMAGINARY (IMAGINARIO) 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\/imaginary\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/imaginary\/\",\"name\":\"Funci\u00f3n IMAGINARY (IMAGINARIO) 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:50:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n IMAGINARY (IMAGINARIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/imaginary\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/imaginary\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/imaginary\/#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\":\"IMAGINARIO\"}]},{\"@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 IMAGINARY (IMAGINARIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n IMAGINARY (IMAGINARIO) 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\/imaginary\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n IMAGINARY (IMAGINARIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n IMAGINARY (IMAGINARIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/imaginary\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:50:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n IMAGINARY (IMAGINARIO) 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\/imaginary\/","url":"https:\/\/functiontranslator.com\/es\/imaginary\/","name":"Funci\u00f3n IMAGINARY (IMAGINARIO) 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:50:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n IMAGINARY (IMAGINARIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/imaginary\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/imaginary\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/imaginary\/#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":"IMAGINARIO"}]},{"@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\/14014","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=14014"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14014\/revisions"}],"predecessor-version":[{"id":30071,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14014\/revisions\/30071"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}