Spread Formula Reference
COMPLEX
Formula Functions > Functions A to C > 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.

For more information, refer to Complex Numbers in Engineering Functions.

Data Types

Accepts number and string data. Returns string data.

Examples

COMPLEX(3,5)

COMPLEX(3,5,"j")

Version Available

This function is available in product version 2.0 or later.

See Also

IMAGINARY | IMREAL | Engineering Functions | Complex Numbers in Engineering Functions