How to Use the FLOOR Function in Google Sheets

How to Use the FLOOR Function in Google Sheets
Reading Time: 3 minutes

Objective

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

About FLOOR Function in Google Sheets

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.

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”.

Examples

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:
=FLOOR(11,2)
  • 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 of using FLOOR function for a positive integer value
Figure 1: Example of using FLOOR function for a positive integer value

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:
=FLOOR(21.75,0.5)
  • 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 of using FLOOR function for decimal value
Figure 2: Example of using FLOOR function for decimal value

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

  • To use the function for ZERO using a factor, use:
=FLOOR(0,1)
  • 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 of using FLOOR function for ZERO value
Figure 3: Example of using FLOOR function for ZERO value

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:
=FLOOR(-3.5,2)
  • 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

Example of using FLOOR function for a negative integer value
Figure 4: Example of using FLOOR function for a negative integer value

Conclusion

You can use the FLOOR function to find the lower value based on a specified factor. You can go through the documentation of the FLOOR function in Google Sheets by clicking here.

See Also

How to Create a Drop-Down List in Google Sheets: Learn how to create drop-down lists in Google Sheets.

Filter data in Google Sheets using Slicer | Slice Table rows conditionally: Learn how to Filter data in Google Sheets using Slicer.

Conditional Formatting in Google Sheets: Get started with Conditional Formatting in Google Sheets