Advertisements
MANTISSA()
Determines the mantissa of a floating point number (base2)
------------------------------------------------------------------------------
Syntax
MANTISSA(<nFloatingPointNumber>) --> nMantissa
Arguments
<nFloatingPointNumber> Designates any decimal number.
Returns
MANTISSA() returns the mantissa of the <nFloatingPointNumber> number.
Description
This function supplements EXPONENT() to return the mantissa of the
<nFloatingPointNumber> number.
Notes
. The mantissa value can be 0 or in the range of 1 to 2.
. The following calculation reproduces the original value:
MANTISSA(<nFloatingPointNumber>)* 2^EXPONENT(<FloatingPointNumber =
<nFloatingPointNumber>)
Example
Display the mantissa for the following values:
? MANTISSA(0) // Result: 0.00
? MANTISSA(100) // Result: 1.56
? MANTISSA(INFINITY) // Result: 2.00
? MANTISSA(0.01) // Result: 1.28
? MANTISSA(-100) // Result: -1.56
? MANTISSA(-0.01) // Result: -1.28
? MANTISSA(-1.01) // Result: -1.01
? MANTISSA(-2.01) // Result: -1.01
See Also: EXPONENT()
Advertisements