FLOOR
Usage
Use this function to round a decimal number to its closest lowest 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
=FLOOR(10.8)
Description
Round 10.8 to its closest lowest integer value
Result
10
Example 2
Formula
=FLOOR(#StorageExample.Number.VALUE)
Description
Round value of the column values Number in the StorageExample to its closest lowest integer value
Result
Integer