All of them refer to the same thing.
The IMABS function always returns a positive number.
For example, consider the complex number “-12-5i” which points in a different direction.
The absolute value of this complex number is positive 13.
In general, the absolute value of a complex number “z=x+yi” is given by the formula below.
Notes
Images courtesy ofwumbo.net.
IMARGUMENT Function
The Excel IMARGUMENT function returns the angle of a complex number expressed in radians.
IMREAL Function
The Excel IMREAL function returns the real part of a complex number.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number.
