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

Descripci\u00f3n General de la Funci\u00f3n de Substracci\u00f3n de N\u00fameros Complejos<\/h2>\n

En Excel y Google Sheets, hay una funci\u00f3n dise\u00f1ada espec\u00edficamente para la substracci\u00f3n de n\u00fameros complejos. Esta herramienta es muy \u00fatil en \u00e1reas como la ingenier\u00eda el\u00e9ctrica, donde el manejo de n\u00fameros complejos es com\u00fan. La funci\u00f3n acepta dos argumentos, cada uno un n\u00famero complejo, y retorna la diferencia entre el primero y el segundo.<\/p>\n

Sintaxis y Ejemplos de Uso<\/h2>\n

La sintaxis para utilizar esta funci\u00f3n en Excel es:<\/p>\n

=IM.SUSTR(complejo1, complejo2)<\/code><\/pre>\n
En Google Sheets, la sintaxis es id\u00e9ntica:<\/p>\n
=IM.SUSTR(complejo1, complejo2)<\/code><\/pre>\n
Aqu\u00ed, complejo1<\/code> y complejo2<\/code> son los n\u00fameros complejos que se quieren substrar, y deben ser introducidos como texto en el formato \u00aba+bi\u00bb o \u00aba-bi\u00bb, donde \u00aba\u00bb representa la parte real y \u00abb\u00bb la parte imaginaria del n\u00famero complejo.<\/p>\n
Ejemplo:<\/strong> Para substraer el n\u00famero complejo 5+3i de 2+2i, usar\u00edas la f\u00f3rmula:<\/p>\n
=IM.SUSTR(\"5+3i\", \"2+2i\")<\/code><\/pre>\n
Esto resultar\u00e1 en \u00ab3+i\u00bb, y ser\u00e1 mostrado en la celda donde se ingres\u00f3 la f\u00f3rmula.<\/p>\n
Casos Pr\u00e1cticos de Uso<\/h2>\n
He aqu\u00ed algunos contextos pr\u00e1cticos donde esta funci\u00f3n es particularmente valiosa:<\/p>\n
    \n
  • Electr\u00f3nica y Circuitos:<\/strong> En el an\u00e1lisis de circuitos el\u00e9ctricos, los n\u00fameros complejos son fundamentales para representar impedancias y voltajes. Substraer voltajes complexivos puede facilitar la determinaci\u00f3n de la diferencia de potencial entre dos puntos en un circuito.<\/li>\n
  • Matem\u00e1ticas y F\u00edsica:<\/strong> En f\u00edsica te\u00f3rica y matem\u00e1ticas aplicadas, los n\u00fameros complejos son cruciales. La capacidad de substraer estos n\u00fameros es esencial al resolver ecuaciones diferenciales o analizar fen\u00f3menos como ondas y oscilaciones.<\/li>\n<\/ul>\n
    Ejemplos Detallados<\/h2>\n
    Ejemplo 1:<\/strong> Imagina que est\u00e1s trabajando en un problema de circuitos y necesitas hallar la diferencia de voltaje entre dos nodos con voltajes representados por los n\u00fameros complejos 7+2i y 3+5i volts.<\/p>\n
    =IM.SUSTR(\"7+2i\", \"3+5i\")<\/code><\/pre>\n
    Al ingresar esta f\u00f3rmula en una celda, obtendr\u00e1s \u00ab4-3i\u00bb, indicando una diferencia de voltaje de 4 volts en la parte real y -3 volts en la imaginaria.<\/p>\n
    Ejemplo 2:<\/strong> Sup\u00f3n que est\u00e1s abordando una cuesti\u00f3n f\u00edsica relacionada con ondas donde las amplitudes est\u00e1n modeladas como n\u00fameros complejos. Si la amplitud inicial es 10+6i y luego de un evento es 4+3i, podr\u00edas substraer estos valores para determinar el cambio resultante.<\/p>\n
    =IM.SUSTR(\"10+6i\", \"4+3i\")<\/code><\/pre>\n
    El resultado ser\u00eda \u00ab6+3i\u00bb, reflejando un cambio de 6 unidades en la parte real y 3 en la imaginaria.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la diferencia entre dos n\u00fameros complejos<\/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-14035","post","type-post","status-publish","format-standard","hentry","category-ingenieria"],"acf":[],"yoast_head":"\nFunci\u00f3n IMSUB (IM.SUSTR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMSUB (IM.SUSTR) 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\/imsub\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n IMSUB (IM.SUSTR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IMSUB (IM.SUSTR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/imsub\/\" \/>\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:39+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 IMSUB (IM.SUSTR) 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\/imsub\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/imsub\/\",\"name\":\"Funci\u00f3n IMSUB (IM.SUSTR) 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:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n IMSUB (IM.SUSTR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/imsub\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/imsub\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/imsub\/#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.SUSTR\"}]},{\"@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 IMSUB (IM.SUSTR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n IMSUB (IM.SUSTR) 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\/imsub\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n IMSUB (IM.SUSTR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n IMSUB (IM.SUSTR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/imsub\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:51:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n IMSUB (IM.SUSTR) 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\/imsub\/","url":"https:\/\/functiontranslator.com\/es\/imsub\/","name":"Funci\u00f3n IMSUB (IM.SUSTR) 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:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n IMSUB (IM.SUSTR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/imsub\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/imsub\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/imsub\/#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.SUSTR"}]},{"@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\/14035","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=14035"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14035\/revisions"}],"predecessor-version":[{"id":30110,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14035\/revisions\/30110"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}