ROUNDDOWN Function – Google Sheets
Learn how to use the ROUNDDOWN function in Google Sheets to round a number down.
Math
TRUNC Function – Google Sheets
The TRUNC function in Google Sheets removes unwanted digits from a number. This function can simplify large numbers or convert decimal values to integers. You can also use it to filter data in a spreadsheet. ⚠️ The TRUNC function is similar to the INT function, but TRUNC accepts a place argument and treats negative numbers … Read more
MROUND Function – Google Sheets
Learn how the MROUND function rounds a number to the nearest multiple of a specified factor.
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
CEILING Function – Google Sheets
Learn how to use the CEILING function to round a number up to the nearest integer multiple of a specified significance.