Filter
Top Products
Functions and commands 311
Numbers
Ceiling Smallest integer greater than or equal to value.
CEILING(value)
Examples:
CEILING(3.2) returns 4
CEILING(-3.2)
returns -3
Floor Greatest integer less than or equal to value.
FLOOR(value)
Example:
FLOOR(3.2) returns 3
FLOOR(-3.2)
returns -4
IP Integer part.
IP(value)
Example:
IP(23.2) returns 23
FP Fractional part.
FP(value)
Example:
FP (23.2) returns .2
Round Rounds value to decimal places. Also accepts complex
numbers.
ROUND(value,places)
ROUND can also round to a number of significant digits if
places is a negative integer (as shown in the second example
below).
Examples:
ROUND(7.8676,2) returns 7.87
ROUND(0.0036757,-3)
returns 0.00368
Truncate Truncates value to decimal places. Also accepts complex
numbers.
TRUNCATE(value,places)