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:
Based on the Excel spreadsheet above, the following IMABS examples would return:
- 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: