COMPLEX (create complex number)

<< Click to Display Table of Contents >>

COMPLEX (create complex number)

Syntax:

COMPLEX(Real, Imag [, Suffix])

Description:

Creates a complex number in the form x+yi or x+yj from the specified Real and Imag.

With Suffix (optional) you can determine which letter should be used for the imaginary unit: either "i" or "j" (lower case!). If Suffix is not specified, "i" is automatically used.

Tip:

To enter complex numbers in cells, you can either make use of the COMPLEX function or simply type them in. For example, the complex number 2+4i can be entered either as =COMPLEX(2, 4) or simply as 2+4i.

The same applies for formulas – except for the fact that complex numbers have to be surrounded by double quotation marks ("). For example, instead of typing =IMPOWER(COMPLEX(2, 4)), you could also type =IMPOWER("2+4i").

Example:

COMPLEX(2, 4) returns 2+4i

COMPLEX(2, 4, "i") returns 2+4i as well

COMPLEX(2, 4, "j") returns 2+4j

See also:

IMAGINARY, IMREAL