The COMPLEX function returns a complex number based on specified real and imaginary coefficients.
Complex numbers have the form a + bi, where a is the real part, b is the imaginary part, and i or j is the imaginary unit.
Syntax
COMPLEX(real_number, imaginary_number, [suffix])
Argument |
Description |
Permitted values |
|---|---|---|
real_number |
Real part of a complex number |
Any numerical value |
imaginary_number |
Imaginary part of a complex number |
Any numerical value |
[suffix] |
(optional) The symbol that defines the complex number suffix: “i” or “j”. By default, “i” |
“i” or “j” |
Examples of use
Creating a simple complex number
=COMPLEX(3, 4)
Result: 3 + 4i.
Use with suffix
=COMPLEX(2, 5, "j")
Result: 2 + 5j.
Use with values from cells
=COMPLEX(A1, B1)
If cells A1 and B1 contain real and imaginary parts, the function will create a complex number based on these values.
Notes
This function can be useful when calculating impedance, phase shifts, and other parameters in electrical engineering.