IMABS
Description
Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
Sample Usage
Syntax
IMABS(inumber)
The IMABS function syntax has the following arguments:
Inumber Required. A complex number for which you want the absolute value.
Remarks
Use COMPLEX to convert real and imaginary coefficients into a complex number.
The absolute value of a complex number is:
where:
z = x + yi
In order to use the IMABS formula, start with your edited Excellentable
Then type in the IMABS formula in the area you would like to display the outcome:
By adding the values you would like to calculate the IMABS formula for, Excellentable will generate the outcome: