SpreadJS Documentation
COMPLEX
SpreadJS Documentation > Formula Reference > Formula Functions > COMPLEX

This function converts real and imaginary coefficients into a complex number.

Syntax

COMPLEX(realcoeff,imagcoeff,suffix)

Arguments

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.

Remarks

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.

Data Types

Accepts number and string data. Returns string data.

Examples

COMPLEX(3,5)

COMPLEX(3,5,"j")

See Also