IMABS Function in Excel – Absolute or modulus of a complex number

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

IMABS Function in Excel 2

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

IMABS Function in Excel 3

NOTE: #NUM! – Error occurs if,

supplied inumber argument is not recognized as a complex number.