@ceil(vXXXX)

Definition

Rounds a value up to the next real number

Returns

Returns the next highest real number (e.g. 2, 10, 65, 149...) based on the result of the parenthesized variable or equation.

Example

Where Inventory (v2040) is 233, this formula:

@ceil(v2040/100) 

calculates the number of trucks necessary to haul the inventory, assuming each truck carries 100 worth of inventory in a period. This example equates to 2.33 and the function rounds result up to 3.