Google Sheets Function: FLOOR

The FLOOR function rounds down a number based on the chosen factor.




=FLOOR(number, factor)

Example of use

To round down a number to 0 decimal places and get an integer, enter:

google sheets floor function integer

This formula is equivalent to:


To round down a number to 2 decimal places, enter 0.01 as the second argument:

google sheets floor function 2 decimals