IMAGINARY

Excel Functions

Get the imaginary part of a complex number

Syntax

EXCEL

=IMAGINARY(inumber)

Arguments

Parameter	Description
`inumber`	The string representing a complex number.

Return Value

The imaginary part of a complex number

Details

The Excel IMAGINARY function returns the imaginary part of a complex number. For example: A complex number is drawn as an arrow in the complex plane, where the horizontal axis corresponds to the real part of the number and the vertical axis corresponds to the imaginary part of the number. For example, the complex number "2-5i" is drawn below. The IMAGINARY function returns the vertical component of the complex number. Images courtesy of wumbo.net.

Examples

Example 1

The Excel IMAGINARY function returns the imaginary part of a complex number. For example:

EXCEL

=IMAGINARY("4+3i") // returns 3

Explanation

The IMAGINARY function returns the vertical component of the complex number.

EXCEL

=IMAGINARY("2-5i") // returns -5

IMAGINARY

Syntax

Arguments

Return Value

Details

Examples

See Also