CEILING
Usage
Use this function to round a decimal number to its closest highest integer value
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER ROW | NUMERIC | .VALUE |
Syntax
1 | |
Arguments
Value
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant or function-returned numeric value
Return Value
Integer
Examples
Example 1
Formula
=CEILING(10.8)
Description
Round 10.8 to its closest highest integer value
Result
11
Example 2
Formula
=CEILING(#StorageExample.Number.VALUE)
Description
Round value of the column values Number in the StorageExample to its closest highest integer value
Result
Integer