IMABSReturns 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