FLOOR Function – Google Sheets

The FLOOR function in Google Sheets rounds a number down to the nearest integer multiple of a specified significance. If the value is negative, and the factor is negative, this function rounds the value up towards zero. The FLOOR.MATH and FLOOR.PRECISE functions are more robust replacements for the FLOOR function. Syntax =FLOOR(value, factor) value – … Read more