Chapter 10: PowerScript Functions

Ceiling

Determines the smallest whole number that is greater than or equal to a specified limit.

Ceiling ( n )

Argument	Description
n	The number for which you want the smallest whole number that is greater than or equal to it

The datatype of n. Returns the smallest whole number that is greater than or equal to n. If n is null, Ceiling returns null.

These statements set num to 5:

decimal dec, num

dec = 4.8

num = Ceiling(dec)

These statements set num to –4:

decimal num

num = Ceiling(-4.2)

num = Ceiling(-4.8)