Documentation/Calc Functions/IMAGINARY

Function name:
IMAGINARY

Category:
Add-in

Summary:
Extracts the imaginary part of a complex number.

Syntax:
IMAGINARY(ComplexNumber)

Returns:
Returns a real number which is the imaginary part of the complex number passed as argument.

Arguments:
ComplexNumber is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to a cell containing that string, whose imaginary part is to be extracted. a and b are real numbers.


 * If ComplexNumber is not a valid complex number, IMAGINARY reports an invalid argument error (Err:502).

Details specific to IMAGINARY function
For a complex number of the form a+bi or a+bj, the IMAGINARY function extracts and returns the value b.

Related LibreOffice functions:
IMABS

IMARGUMENT

IMREAL

ODF standard:
Section 6.8.4, part 2

Equivalent Excel functions:
IMAGINARY