Engineering - IMAGINARY Function

Description

The IMAGINARY function returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

Syntax

IMAGINARY (inumber)

Arguments

Notes

• Use COMPLEX to convert real and imaginary coefficients into a complex number.

• inumber can be supplied to the function Imaginary as any of the following −

  • A simple number;

  • A complex number encased in quotation marks − e.g. "5 + 3i";

  • A reference to a cell containing a complex number or a numeric value;

  • A value returned from another Excel function or formula.

• If Inumber is not recognized as a complex number, the function IMABS returns a #NUM! error.

• If Inumber is a logical value, the function IMABS returns a #VALUE! Error.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example