How to use IMABS Function in Excel

The Excel IMABS function returns the absolute value of a complex number in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real and imaginary parts.

Syntax: =IMABS (inumber)

The IMABS function syntax has the following arguments:

  • Inumber    Required. A complex number for which you want the absolute value.

Example: Let’s look at some Excel IMABS function examples and explore how to use the IMABS function as a worksheet function in Microsoft Excel:

IMABS Function in Excel 2 - How to use IMABS Function in Excel

Syntax:  =IMABS(A2)

Result:

IMABS Function 1 - How to use IMABS Function in Excel

Based on the Excel spreadsheet above, the following IMABS examples would return:

Syntax: =IMABS(A3)
Result: 4.472135955

Syntax: =IMABS(A4)
Result: 5

Syntax: =IMABS(A5)
Result: 8

Syntax: =IMABS(A6)
Result: 13

Syntax: =IMABS(A7)
Result: 7.071067812

Syntax: =IMABS(A8)
Result: 6.32455532

Syntax: =IMABS(A9)
Result: 2.5

Syntax: =IMABS(A10)
Result: 5

Syntax: =IMABS(A11)
Result: 13

Syntax: =IMABS(A12)
Result: 104.4030651

Syntax: =IMABS(A13)
Result: 5

Note:

  • Use COMPLEX to convert real and imaginary coefficients into a complex number.
  • If Inumber is not recognized as a complex number, the function IMABS returns a #NUM! error.
  • If Inumber is a logical value, the function IMABS returns a #VALUE! Error.
  • The absolute value of a complex number is: IMABS Function in Excel - How to use IMABS Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *