Learn how to round numbers in Google Sheets. You can round up, down, use standard rounding, and more.
Learn how to use the FLOOR.PRECISE function to round numbers down to a specified significance.
Learn how to use the FLOOR.MATH function to round numbers down to a specified significance.
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