Documentation/Calc Functions/IMABS/en

Function name:
IMABS

Category:
Add-in

Summary:
Calculates the absolute value or modulus of a complex number.

Syntax:
IMABS(ComplexNumber)

Returns:
Returns a non-negative, real number which is the absolute value of the complex number passed as argument.

Arguments:
ComplexNumber is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to a cell containing that string, whose absolute value is to be calculated. a and b are real numbers.
 * If ComplexNumber does not have an imaginary part (b equal to 0), the real part can be passed to IMABS as a number rather than a string.
 * If ComplexNumber is not a valid complex number, IMABS reports an invalid argument error (Err:502).

Details specific to IMABS function
For a complex number of the form a+bi or a+bj, the formula for the IMABS function is:

For more information about absolute values, visit Wikipedia's Absolute value page.

Related LibreOffice functions:
IMAGINARY

IMARGUMENT

IMREAL

ODF standard:
Section 6.8.3, part 2

Equivalent Excel functions:
IMABS