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

IMABS Function in Excel 1

Syntax of IMABS Function in Excel 

IMABS( inumber )

Where inumber argument is a Complex Number.


Example of IMABS Function in Excel


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 


IMABS Function in Excel 3

NOTE: #NUM! – Error occurs if,

  • supplied inumber argument is not recognized as a complex number.

previous-small IMABS Function in Excel                                                                                                           next_small IMABS Function in Excel

Do NOT follow this link or you will be banned from the site!