Floor()

Working with Formulas > Functions Used in Formulas > Numeric Functions > Floor()

FLOOR() returns the largest number, to the specified precision, that is less than or equal to the input number. If no precision is specified, FLOOR() returns the largest integer less than or equal to the input number.

Function Format

FLOOR(number [, precision]) 

Return Value

FLOOR() returns a numeric value 

Examples

FLOOR(10.333) = 10 

FLOOR(-10.333) = -11 

FLOOR(10.333, 2) = 10.33 

FLOOR(-10.333, 2) = -10.34 

FLOOR(1024, -2) = 1000