Returns the absolute value of a complex number.
Sample Usage
IMABS("3+4i")
IMABS("6j")
Syntax
IMABS(number)
number
- The complex number to calculate the absolute value of.
Notes
- The absolute value (or modulus) is defined as follows:
-
See also
COMPLEX
: The COMPLEX function creates a complex number, given real and imaginary coefficients.IMREAL
: Returns the real coefficient of a complex number.IMAGINARY
: Returns the imaginary coefficient of a complex number.
Examples
1 | A | B |
---|---|---|
2 | Formula | Result |
3 | =IMABS("3+4i") |
5 |
4 | =IMABS(COMPLEX(3, 4, "j")) |
5 |