{"id":14029,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/im-real\/"},"modified":"2021-02-26T08:51:26","modified_gmt":"2021-02-26T08:51:26","slug":"imreal","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/imreal\/","title":{"rendered":"IM.REAL"},"content":{"rendered":"<p>La funci\u00f3n IMREAL en Excel y Google Sheets es extremadamente \u00fatil para trabajar con n\u00fameros complejos. Esta funci\u00f3n extrae la parte real de un n\u00famero complejo, un procedimiento cr\u00edtico en varios campos como matem\u00e1ticas, ingenier\u00eda y f\u00edsica. A continuaci\u00f3n, exploraremos c\u00f3mo utilizar esta funci\u00f3n a trav\u00e9s de ejemplos claros y pr\u00e1cticos.<\/p>\n<h2>Sintaxis y Uso B\u00e1sico<\/h2>\n<p>La sintaxis de la funci\u00f3n IMREAL es la siguiente:<\/p>\n<pre><code>IMREAL(n\u00famero_complejo)<\/code><\/pre>\n<p>Donde <code>n\u00famero_complejo<\/code> es una cadena de texto que representa el n\u00famero complejo del cual queremos obtener su parte real. Este n\u00famero debe estar en el formato \u00aba+bi\u00bb o \u00aba-bi\u00bb, donde \u00aba\u00bb representa la parte real y \u00abb\u00bb la parte imaginaria.<\/p>\n<p>Por ejemplo:<\/p>\n<pre><code>=IMREAL(\"5+3i\")<\/code><\/pre>\n<p>Esta f\u00f3rmula devolver\u00e1 5, que es la parte real del n\u00famero complejo \u00ab5+3i\u00bb.<\/p>\n<h2>Ejemplos de Aplicaciones Pr\u00e1cticas<\/h2>\n<h2>An\u00e1lisis de N\u00fameros Complejos en Circuitos El\u00e9ctricos<\/h2>\n<p>En la ingenier\u00eda el\u00e9ctrica, los n\u00fameros complejos se utilizan para describir las impedancias en circuitos de corriente alterna (AC). Consideremos que deseamos conocer la parte real de la impedancia de varios componentes de un circuito representados en una hoja de c\u00e1lculo:<\/p>\n<table>\n<tr>\n<th>Componente<\/th>\n<th>Impedancia (Formato Complejo)<\/th>\n<th>Parte Real<\/th>\n<\/tr>\n<tr>\n<td>Resistor<\/td>\n<td>50+0i<\/td>\n<td>=IMREAL(B2)<\/td>\n<\/tr>\n<tr>\n<td>Inductor<\/td>\n<td>0+30i<\/td>\n<td>=IMREAL(B3)<\/td>\n<\/tr>\n<tr>\n<td>Capacitor<\/td>\n<td>0-20i<\/td>\n<td>=IMREAL(B4)<\/td>\n<\/tr>\n<\/table>\n<p>En este ejemplo, las impedancias reales del resistor, inductor y capacitor son 50, 0 y 0, respectivamente.<\/p>\n<h2>Procesamiento de Se\u00f1ales y Filtrado<\/h2>\n<p>En el procesamiento de se\u00f1ales, los n\u00fameros complejos son frecuentemente utilizados para representar se\u00f1ales en el dominio de la frecuencia. Supongamos que necesitamos filtrar se\u00f1ales eliminando aquellas cuya parte real sea inferior a 10. Para ello, podr\u00edamos emplear la siguiente f\u00f3rmula:<\/p>\n<pre><code>Si(IMREAL(\"12+7i\") > 10; \"Mantener\", \"Filtrar\")<\/code><\/pre>\n<p>En este caso, la funci\u00f3n devuelve \u00abMantener\u00bb, puesto que la parte real del n\u00famero complejo \u00ab12+7i\u00bb es 12, que es superior a 10.<\/p>\n<p>Utilizar la funci\u00f3n IMREAL puede mejorar considerablemente el an\u00e1lisis y procesamiento de datos en \u00e1mbitos t\u00e9cnicos que involucran n\u00fameros complejos, facilitando la manipulaci\u00f3n de estos y contribuyendo a la toma de decisiones basadas en criterios precisos sobre sus partes reales.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devuelve el coeficiente real 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-14029","post","type-post","status-publish","format-standard","hentry","category-ingenieria"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n IMREAL (IM.REAL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMREAL (IM.REAL) 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\/imreal\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n IMREAL (IM.REAL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMREAL (IM.REAL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/imreal\/\" \/>\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:26+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 IMREAL (IM.REAL) 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\/imreal\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/imreal\/\",\"name\":\"Funci\u00f3n IMREAL (IM.REAL) 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:26+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n IMREAL (IM.REAL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/imreal\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/imreal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/imreal\/#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.REAL\"}]},{\"@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 IMREAL (IM.REAL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n IMREAL (IM.REAL) 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\/imreal\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n IMREAL (IM.REAL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n IMREAL (IM.REAL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/imreal\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:51:26+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n IMREAL (IM.REAL) 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\/imreal\/","url":"https:\/\/functiontranslator.com\/es\/imreal\/","name":"Funci\u00f3n IMREAL (IM.REAL) 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:26+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n IMREAL (IM.REAL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/imreal\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/imreal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/imreal\/#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.REAL"}]},{"@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\/14029","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=14029"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14029\/revisions"}],"predecessor-version":[{"id":30102,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14029\/revisions\/30102"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}