CT_FLOOR

 FLOOR()
 Rounds down to the next integer
------------------------------------------------------------------------------
 Syntax

     FLOOR(<nValue>) --> nSmallerInteger

 Argument

     <nValue>  Designates the number for which the next-smaller integer
     is determined.

 Returns

     FLOOR() returns the next-smaller integer of the one passed as a
     parameter.

 Description

     FLOOR() always returns the next-smaller integer of the one passed as a
     parameter.  This applies to positive and negative numbers.

 Example

     Show the next-smaller integer for positive and negative numbers:

     ? FLOOR(1.9)       // Result:  1
     ? FLOOR(1.1)       // Result:  1
     ? FLOOR(0.9)       // Result:  0
     ? FLOOR(-0.1)      // Result: -1
     ? FLOOR(-0.9)      // Result: -1
     ? FLOOR(-1.1)      // Result: -2

See Also: CEILING()

 

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.