Get the string representation of a complex number
=COMPLEX(real_num, i_num, [suffix])| Parameter | Description |
|---|---|
real_num |
The real part of the complex number. |
i_num |
The imaginary part of the complex number. |
suffix |
[optional] The suffix for the imaginary unit, either "i" or "j". |
The COMPLEX function returns the string representation of a complex number. For example:
=COMPLEX(4,3) // returns "4+3i"To use the "j" instead of "i":
=COMPLEX(4,3,"j") // returns "4+3j"To enter the value of a complex number without using the COMPLEX function, write it in a formula like this:
="4+3i"The Excel formula engine handles complex numbers as strings formatted like "x+yi" or "x+yj". For example, when we add two complex numbers together usi
=IMSUM("4+3i","2-5i") // returns "6-2i"We can perform the same operation using COMPLEX to get the strings representing the complex numbers.
=IMSUM(
COMPLEX(4, 3),
COMPLEX(2,-5)
) // returns "6-2i"