floor

Google Sheets Math Floor. Description the google sheets floor function returns a number rounded down to the nearest multiple of significance. #1 to round the value in b1 cell down to nearest multiple of 2, just using the following excel formula:

Instead of using the cell references in the floor formula in column c, you can use the formulas as below. In this formula 8 is the “value” and 3 is the “factor”. This can be used, for instance, to round down to a particular denomination.