IMABS Function in Excel returns the absolute value (the modulus) of a complex number.
Modulus of a Complex Number
The absolute value or modulus of a complex number is calculated as the square root of the sum of the squares of the real and imaginary coefficients.
The modulus of the complex number, z = x + iy is
Syntax of IMABS Function in Excel
IMABS( inumber )
Where inumber argument is a Complex Number.
Example of IMABS Function in Excel
Formula
- From Row number 2 to 5 IMABS Function takes up real component, imaginary component as a reference
- In row number 6 IMABS Function takes up complex number(imaginary component) as a value which should be enclosed in double quotes
- In row number 7 IMABS Function takes up real component as a value
Result
NOTE: #NUM! – Error occurs if,
- supplied inumber argument is not recognized as a complex number.