COMPLEXThe COMPLEX function creates a complex number, given real and imaginary coefficients.
Sample Usage
COMPLEX(3, 4)
COMPLEX(3, -1, “j”)
COMPLEX(3, 0)
Syntax
COMPLEX(real_part, imaginary_part, [suffix])
real_part – The real coefficient.
imaginary_part – The imaginary coefficient.
suffix – [ OPTIONAL “i” by default] The suffix for the imaginary coefficient.
See Also
IMREAL: Returns the real coefficient of a complex number.
IMAGINARY: Returns the imaginary coefficient of a complex number.
​Examples
1
A
B
2
Formula
Result
3
=COMPLEX(1, 2.5)
1+2.5i
4
=COMPLEX(0, 4, “j”)
4j
5
=COMPLEX(3, -1)
3-i