COMPLEX
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.