For example, the complex number “2-5i” is drawn below.

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

Notes:

Images courtesy ofwumbo.net.

A complex number is drawn as an arrow in the complex plane.

IMREAL Function

The Excel IMREAL function returns the real part of a complex number.

IMABS Function

The Excel IMABS function returns the absolute value of a complex number.

IMARGUMENT Function

The Excel IMARGUMENT function returns the angle of a complex number expressed in radians.

A complex number is drawn as an arrow in the complex plane.

A complex number is drawn as an arrow in the complex plane.

A complex number is drawn as an arrow in the complex plane.

A complex number is drawn as an arrow in the complex plane.

Excel COMPLEX function

Excel IMREAL function

Excel IMABS function

Excel IMARGUMENT function