{"id":13871,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/complejo\/"},"modified":"2021-02-26T08:43:45","modified_gmt":"2021-02-26T08:43:45","slug":"complex","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/complex\/","title":{"rendered":"COMPLEJO"},"content":{"rendered":"

Descripci\u00f3n General y Sintaxis<\/h2>\n

La funci\u00f3n COMPLEJO en Excel y Google Sheets se utiliza para convertir componentes reales e imaginarios en un n\u00famero complejo expresado como texto. Esta funci\u00f3n es de gran utilidad en el \u00e1mbito de los c\u00e1lculos matem\u00e1ticos que requieren el uso de n\u00fameros complejos, especialmente en disciplinas como la ingenier\u00eda y la f\u00edsica.<\/p>\n

La sintaxis en Excel es la siguiente:<\/p>\n

=COMPLEJO(real, imaginario, [sufijo])<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • real<\/strong>: Representa el componente real del n\u00famero complejo.<\/li>\n
  • imaginario<\/strong>: Representa el componente imaginario del n\u00famero complejo.<\/li>\n
  • sufijo<\/strong> (opcional): Indica la unidad imaginaria, que suele ser \u00abi\u00bb o \u00abj\u00bb. Si no se especifica, el valor por defecto es \u00abi\u00bb.<\/li>\n<\/ul>\n
    En Google Sheets, la sintaxis es similar:<\/p>\n
    =COMPLEJO(real, imaginario, [sufijo])<\/code><\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    1. Creaci\u00f3n de N\u00fameros Complejos para C\u00e1lculos de Ingenier\u00eda<\/h2>\n
    Los ingenieros el\u00e9ctricos frecuentemente emplean n\u00fameros complejos para el an\u00e1lisis de circuitos con corrientes alternas. Por ejemplo, si necesitan representar un n\u00famero complejo con un componente real de 4 y un componente imaginario de 3:<\/p>\n
    =COMPLEJO(4, 3)<\/code><\/pre>\n
    El resultado ser\u00e1:<\/p>\n
    4 + 3i<\/code><\/p>\n
    Si prefieren utilizar \u00abj\u00bb como la unidad imaginaria, que es com\u00fan en ingenier\u00eda el\u00e9ctrica, la f\u00f3rmula se modificar\u00eda de la siguiente manera:<\/p>\n
    =COMPLEJO(4, 3, \"j\")<\/code><\/pre>\n
    Y el resultado ser\u00e1:<\/p>\n
    4 + 3j<\/code><\/p>\n
    2. Operaciones con N\u00fameros Complejos en Matem\u00e1ticas<\/h2>\n
    Para un profesor explicando operaciones con n\u00fameros complejos, es \u00fatil demostrar c\u00f3mo se suman dos n\u00fameros complejos, como (3 + 4i) y (1 + 2i).<\/p>\n
    Primero, se crean cada n\u00famero complejo con la funci\u00f3n COMPLEJO:<\/p>\n
    =COMPLEJO(3, 4) =COMPLEJO(1, 2)<\/code><\/pre>\n
    Aunque Excel y Google Sheets no suman directamente n\u00fameros complejos en forma textual, esta inicializaci\u00f3n es \u00fatil para explicaciones o para integrarla en funciones que s\u00ed gestionan operaciones complejas. La suma se realizar\u00eda manualmente:<\/p>\n
    Suma del componente real: 3 + 1 = 4<\/p>\n
    Suma del componente imaginario: 4 + 2 = 6<\/p>\n
    El resultado de la suma ser\u00eda:<\/p>\n
    4 + 6i<\/code><\/p>\n
    A trav\u00e9s de este enfoque paso a paso, podemos ense\u00f1ar de manera pr\u00e1ctica c\u00f3mo se realizan estas sumas, antes de recurrir a otras funciones o herramientas m\u00e1s avanzadas que automatizan la operaci\u00f3n.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Convierte coeficientes reales e imaginarios en 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-13871","post","type-post","status-publish","format-standard","hentry","category-ingenieria"],"acf":[],"yoast_head":"\nFunci\u00f3n COMPLEX (COMPLEJO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COMPLEX (COMPLEJO) 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\/complex\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n COMPLEX (COMPLEJO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COMPLEX (COMPLEJO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/complex\/\" \/>\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:43:45+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 COMPLEX (COMPLEJO) 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\/complex\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/complex\/\",\"name\":\"Funci\u00f3n COMPLEX (COMPLEJO) 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:43:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n COMPLEX (COMPLEJO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/complex\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/complex\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/complex\/#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\":\"COMPLEJO\"}]},{\"@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 COMPLEX (COMPLEJO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n COMPLEX (COMPLEJO) 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\/complex\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n COMPLEX (COMPLEJO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n COMPLEX (COMPLEJO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/complex\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:43:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n COMPLEX (COMPLEJO) 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\/complex\/","url":"https:\/\/functiontranslator.com\/es\/complex\/","name":"Funci\u00f3n COMPLEX (COMPLEJO) 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:43:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n COMPLEX (COMPLEJO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/complex\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/complex\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/complex\/#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":"COMPLEJO"}]},{"@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\/13871","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=13871"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13871\/revisions"}],"predecessor-version":[{"id":29934,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13871\/revisions\/29934"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}