CT_CEILING

 CEILING()
 Rounds up to the next integer
------------------------------------------------------------------------------
 Syntax

     CEILING(<nValue>) --> nLargerInteger

 Argument

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

 Returns

     CEILING() returns the next-largest integer to the one that is passed as
     a parameter.

 Description

     CEILING() returns the next-largest integer to the one passed as a
     parameter.  This applies to positive and negative numbers.

 Example

     Show the next-largest integer (including positive and negative numbers):

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

See Also: FLOOR()

 

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.