Google Sheets Function: FLOOR

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

Usage:

=FLOOR(number)

or

=FLOOR(number, factor)


Example of use

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

=FLOOR(A2)

google sheets floor function integer

This formula is equivalent to:

=FLOOR(A2,1)

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

=FLOOR(A2,0.01)

google sheets floor function 2 decimals