# IMABS Function in Excel

## IMABS Function in Excel

The IMABS function in Excel returns the absolute value (modulus) of a complex number in x + yi or x + yj format.

### Syntax

`= IMABS(inumber)`

### Arguments:

• Inumber    – The complex number for which you want the absolute value.

## How IMABS works?

The COMPLEX function combines the real and imaginary parts into a complex form or a complex equation in the format x+yi or x+yj.

To get the absolute value of a complex number or equation we use the IMABS function in Excel

i.e., IMABS(z) =|z| =(sqrt(x^2+y^2))

where:

z = x + yi

## How to use the COMPLEX function in Excel?

Using this function in a WS is simple, all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

To find out the absolute value of the complex numbers, Enter the complex numbers in column A and enter the following formula in Column B,

Formula: =IMABS(A1)

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the absolute value of the complex form.