FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value. How to use
FLOOR
formula?  Examples of using
FLOOR
formula FLOOR
formula not working? Similar formulas to
FLOOR
Usage
Use the FLOOR
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value (required):
The number or reference to the cell containing the number to be rounded down.  factor (optional):
Optional parameter that specifies the multiple to which to round the value down. If omitted, the function rounds to the nearest integer.
Examples
Here are a few example use cases that explain how to use theFLOOR
formula in Google Sheets.
Rounding down to nearest integer
The FLOOR formula can be used to round a number down to the nearest integer. This is useful when working with data that requires whole numbers, such as counting or indexing.
Rounding down to nearest multiple of a factor
By providing a factor to the FLOOR formula, a number can be rounded down to the nearest multiple of that factor. This is often used when working with financial data, where amounts are denominated in specific increments.
Rounding down to nearest hour
The FLOOR formula can be used to round down a time value to the nearest hour. This is helpful when working with timebased data and needing to aggregate data by hour.
Common Mistakes
FLOOR
not working? Here are some common mistakes people make when using the FLOOR
Google Sheets Formula:
Not providing a value to the function
If you forget to provide a value argument to the FLOOR function, it will return an error. Make sure to provide a value to the function.
Providing a nonnumeric value to the function
The FLOOR function only works with numeric values, so if you provide a nonnumeric value, it will return an error. Make sure to provide a numeric value to the function.
Providing a factor that is not a positive integer
The factor argument in the FLOOR function must be a positive integer. If you provide a nonpositive integer, it will return an error. Make sure to provide a positive integer as the factor argument.
Misunderstanding how the factor argument works
The factor argument in the FLOOR function is optional and is used to round the value down to the nearest multiple of the factor. If you provide a factor argument that is larger than the value or that does not evenly divide the value, it will round down to 0. Make sure to understand how the factor argument works before using it.
Forgetting to use the FLOOR function when rounding down
If you want to round a value down to the nearest integer or to the nearest multiple of a factor, make sure to use the FLOOR function. If you use a different function or method, you may get unexpected results.
Related Formulas
The following functions are similar to FLOOR
or are often used with it in a formula:

CEILING
The
CEILING
function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments. 
ROUND
The
ROUND
formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If theplaces
parameter is not specified, the formula rounds to the nearest integer. 
MROUND
The
MROUND
function rounds a number to the nearest multiple of a specified factor. It is commonly used when dealing with financial data, such as currency or interest rate calculations. 
INT
The
INT
formula rounds a given value down to the nearest integer. This formula is often used to simplify large numbers or to convert decimal values to integers. The formula takes a single parameter, the value to be rounded down. If the value is already an integer, the formula will return the same value. If the value is a decimal, the formula will round down to the nearest integer.
Learn More
You can learn more about the FLOOR
Google Sheets function on Google Support.