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 |