The Excel IMABS function returns the absolute value (modulus) of a complex number — part of Excel’s complex-number toolkit for engineering and signal analysis.
Syntax
| Argument | Description | |
|---|---|---|
inumber | Required | A complex number as text. |
How to use it
IMABS returns the absolute value (modulus) of a complex number. Complex numbers are written as text like "3+4i" (or with a "j" suffix). Build them with COMPLEX and pull the parts back out with IMREAL and IMAGINARY.
All IM functions take and return text. Keep complex numbers as text strings throughout your calculation chain; use IMREAL / IMAGINARY only when you need numeric parts for charts or further math.
Try it: interactive demo
Enter a complex number (a+bi) and see the formula IMABS would evaluate.
Practice workbook
Frequently asked questions
How are complex numbers stored in Excel?
Does IMABS return text or a number?
Can I mix i and j suffixes?
What if my real or imaginary part is zero?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class