Ceil

(Engine-Level Function)

Description: Returns the smallest integer greater than or equal to a number (the ceiling).
Returns: Numeric
Usage: Script or steady state.
Function Groups: Rounding Math
Related to: Int | Step
Format: Ceil(X)
Parameters:  
X
Required. Any numeric expression for which the ceiling should be determined.
Comments: This function performs function similar to that of the Int function, except that it goes to the next highest number.

Example:

  A = Ceil(1.00);
  B = Ceil(1.01);
  C = Ceil(1.99);

The values of A, B and C will be 1, 2 and 2 respectively.