Using the 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
InumberRequired. 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.