Excel IMABS Function

Using the Excel IMABS Function

Excel IMABS Function

Summary

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.

Syntax

=IMABS (inumber)

Syntax Breakdown

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