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()