The 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 |
