In this tutorial, you will learn how to round down values in Google Sheets.
How To Round Down in Google Sheets
When working with numbers in Google Sheets, there may be times when you want to round a number down to the nearest integer.
For example, if you have a decimal value such as 3.14, you may want to round it down to 3.
Google Sheets offers two functions that can help you round down numbers: ROUNDDOWN and FLOOR.
The FLOOR function can also be used to round down time values. For example, if you have a time value of 1:15, you can use the FLOOR function to round it down to 1:00.
In this guide, we will show you how to use both of these functions to round down numbers.
How To Round Numbers Down in Google Sheets
Here’s how to round numbers down in Google Sheets.
First, we’ll explain how to use the ROUNDDOWN function to round down decimal values in Google Sheets.
Select an empty cell and type ‘=ROUNDDOWN(‘ to start the function.
The ROUNDDOWN function requires us to provide a numerical value for the first argument. This could be written directly into the formula or you may provide a cell reference to a number.
In this example, we’ll add a cell reference to a corresponding value in column A. Themain difference between ROUND and ROUNDDOWN is that the latter will always round down the given value.
Next, we have the option to provide the number of places to which to round. If no number is provided, it will be set to 0.
We may also provide a negative value. This will make the ROUNDDOWN function round down a certain number of digits to the left of the decimal point.
Next, we’ll explain how to use the FLOOR function to round down decimals in Google Sheets.
The FLOOR function is used to round a number down to the nearest integer multiple of specified significance.
Start using the FLOOR function by typing the string “=FLOOR(“ on an empty cell.
Next, provide the number you want to round down as the first argument. For the second argument, indicate the factor you want to round down the first argument with. By default, the factor is set to 1.
If we set the factor to ‘1’, we’ll effectively round down our decimal to the nearest integer.
We can also use the FLOOR function to round down date and time values.
First, enter the date or time as the first argument of FLOOR.
Next, write down “1:00:00” as the second argument if you want to round down to the nearest hour. We can use the string “00:01” to round down to the nearest minute or “00:15” to round down to the nearest quarter hour.
You will likely see a decimal rather than a time. We’ll need to apply number formatting to reveal the actual time.
Click on the number formatting icon to reveal a drop-down list of possible options. Click on Time to convert the decimal to a time format.
You should now have a time rounded down to the nearest indicated unit.
This guide should be everything you need to round down in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More basic math formulas in Google Sheets:
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Sum Columns or Rows
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula