# How to Use the FLOOR Function in Google Sheets

What it does: Rounds a given number down to the nearest specified multiple.

Syntax
`=FLOOR(value,[factor])`

value – A number that the function rounds down.

factor – The number used for rounding the “value” parameter. The “value” will be rounded to the nearest highest multiple of “factor”, smaller than or equal to “value”.

Sample Usage
`=FLOOR(``11``,``2``)`

//This returns 10 as the output–the nearest multiple of 2 to 11.

Objective

Learn how to use the FLOOR function in Google Sheets and examples of its variations.

The Google Sheets FLOOR function rounds a given number down to the nearest specified multiple. You can use the function to round down any number to a positive integer, negative integer or decimal value.

## How to use the FLOOR function in Google Sheets

### Example 1: Using the FLOOR function in Google Sheets for a positive integer value

• To find the floor of a positive value using a factor, use:
• Here, the value is 11 and the factor is 2.
• Since the highest multiple of 2, lower than or equal to 11 is 10, the output will be 10.

### Example 2: Using the FLOOR function in Google Sheets for a decimal value

• To use the function for a decimal value using a factor, use:
• Here, the value is 21.75, which is a decimal number and the factor is 0.5.
• Since the highest multiple of 0.5, lower than or equal to 21.75 is 21.5, the output will be 21.5.

### Example 3: Using the FLOOR function in Google Sheets for ZERO

• To use the function for ZERO using a factor, use:
• Here, the value is 0 and the factor is 1.
• Since value zero doesn’t have any factors, the floor value will ALWAYS be 0.

### Example 4: Using the FLOOR function in Google Sheets for a negative integer value

• To use the function for a negative value using a factor, use:
• Here, the value is -3.5, which is a negative integer and the factor is 2.
• Since the highest multiple of 2, lower than or equal to -3.5 is -4, the output will be -4.

Note: Since the value here is a negative integer, the absolute value of the floor will be greater than the value