How to use the IMAGINARY Function in Excel

Using the Excel IMAGINARY Function

Summary

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

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

Syntax

=IMAGINARY (inumber)

Syntax Breakdown

Inumber
Required. Complex number for which you want to find the imaginary coefficient.

Usage Notes

IMAGINARY returns the imaginary coefficient of a complex number.

The function will return the #NUM! error if a value besides "i" or "j" is entered in the argument.