Get the absolute value of a complex number
=IMABS(inumber)
| Parameter | Description |
|---|---|
inumber |
The string representing a complex number. |
The Excel IMABS function returns the absolute value of a complex number. For example:
=IMABS("4+3i") // returns 5
The absolute value of this complex number is positive 13.
=IMABS("-12-5i") // returns 13
In general, the absolute value of a complex number "z=x+yi" is given by the formula below.
=SQRT(x^2 + y^2)