COMPLEX
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj
Syntax
COMPLEX(real_num, i_num, [suffix])
Parameters
- real_num: Required. The real coefficient of the complex number
- i_num: Required. The imaginary coefficient of the complex number
- suffix: Optional. The suffix for the imaginary component ("i" or "j"). If omitted, suffix is assumed to be "i"
Example
=COMPLEX(3, 4)