| SpreadJS Documentation > Formula Reference > Formula Functions > COMPLEX |
This function converts real and imaginary coefficients into a complex number.
COMPLEX(realcoeff,imagcoeff,suffix)
This function has these arguments:
| Argument | Description |
|---|---|
| realcoeff | Coefficient of the real part of the complex number |
| imagcoeff | Coefficient of the imaginary part of the complex number |
| suffix | (Optional) Suffix of the imaginary part of the complex number, may be either "i "or "j". If omitted, "i" is used. |
For the suffix, use lowercase for "i" and "j" to prevent errors.
An error is returned if the real or imaginary coefficients are non-numeric.
Accepts number and string data. Returns string data.
COMPLEX(3,5)
COMPLEX(3,5,"j")