COMPLEX
Converts real and imaginary coefficients into a complex number.
EngineeringEngineering & Science
What it does
Converts real and imaginary coefficients into a complex number string (x + yi).
Syntax
COMPLEX(real_num, i_num, [suffix])
Arguments
real_num(number) — The real coefficient.i_num(number) — The imaginary coefficient.suffix(text) — Suffix for the imaginary component ("i" or "j").
Examples
Create Complex Number
Convert 3 and 4 to complex.
FORMULA
=COMPLEX(3, 4)
RESULT
3+4i
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Real | Imaginary |
| 2 | 3 | 4 |