Documentation/Calc Functions/COMPLEX

Function name:
COMPLEX

Category:
Add-in

Summary:
Constructs a complex number as text, given its real and imaginary parts.

Syntax:
COMPLEX(RealNumber; ImaginaryNumber[; Suffix])

Returns:
Returns a text string which is the complex number constructed from the given real and imaginary parts, using the given or default imaginary unit.

Arguments:
RealNumber is a real value, or a reference to a cell containing that value, which is the real part of the complex number.

ImaginaryNumber is a real value, or a reference to a cell containing that value, which is the imaginary part of the complex number.

Suffix is the string, or a reference to a cell containing that string, which comprises the letter to be used as the imaginary unit; either “i” or “j” (lowercase only). If omitted, “i” is used.


 * If either RealNumber or ImaginaryNumber is non-numeric, then COMPLEX reports a #VALUE! error.
 * If Suffix is set to something other than “i” or “j”, COMPLEX reports an invalid argument error (Err:502).

Related LibreOffice functions:
None.

ODF standard:
Section 6.8.2, part 2

Equivalent Excel functions:
COMPLEX