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:

**Syntax**: =IMABS(A2)

**Result**:

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: