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.
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.