Navigation:  Formula Reference > Spreadsheet Formula Functions >

COMPLEX

Previous pageReturn to chapter overviewNext page

 

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

IMAGINARY

IMREAL