Using the Excel IMABS Function


The Excel IMABS function returns the absolute value of a complex number in the x + yi or x + yj text format.

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


=IMABS (inumber)

Syntax Breakdown

Required. Complex number for which you want to find the absolute value.

Usage Notes

IMABS returns the modulus, or absolute value, of a complex number in a format such as x + yi or x + yj.

The function returns the #NUM! error if a value besides "i" or "j" is used.