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:
