Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelIMABS Function in Excel

# IMABS Function in Excel

In this article, you will learn about the IMABS function, its usage, syntax and how to use it in your excel spreadsheet.

## 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.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021