=FLOOR
The =FLOOR() function returns the largest integer value that is less than or equal to the specified number.
Syntax
Section titled “Syntax”=FLOOR(AnyNumber)Parameters
Section titled “Parameters”-
AnyNumber
- Any numeric value (integer or decimal) to be rounded downward.
How It Works
Section titled “How It Works”-
Removes the decimal portion of a number by rounding down to the nearest whole integer.
-
If the value is already an integer, it is returned unchanged.
Usage Notes
Section titled “Usage Notes”-
Works with positive and negative numbers.
-
Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=FLOOR(3.8)Returns: 3
Keywords
Section titled “Keywords”FLOOR, rounding down, integer rounding, math function, numeric functions, formula function, workflow formulas