CT_MANTISSA

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

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.