The ROUNDDOWN function in Google Sheets rounds a number down to a specified number of decimal places. It does not use standard rounding rules; instead, it rounds all numbers down.
⚠️ The ROUNDDOWN function changes a number’s value, while number formatting changes its display. If you change the look of a number with formatting, the full value of the number remains, but you don’t see it. If you remove places with this function, the unrounded value is permanently removed.
Syntax
=ROUNDDOWN(value, [places])
value– The number you want to round.places– Optional. The number of decimal places you want to round to. If you don’t specify aplacevalue, the default is0.
Similar Functions
Several functions deal with rounding. Choose the most appropriate for your use.
- CEILING.MATH – Rounds a number up to the nearest integer multiple of specified significance with custom negative number treatment
- CEILING.PRECISE – Rounds a number up to the nearest integer multiple of specified significance
- INT – Rounds a number down to the nearest integer
- FLOOR.MATH – Rounds a number down to the nearest integer multiple of specified significance with custom negative number treatment
- FLOOR.PRECISE – Rounds a number down to the nearest integer multiple of specified significance
- MROUND – Rounds a number to the nearest multiple of another number
- ROUND – Rounds a number to a specified number of decimal places using standard rounding
- ROUNDDOWN – Round a number down to a specified number of places
- ROUNDUP – Round a number up to a specified number of places
- TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits
Insert Math Symbols (Add-On)
Examples
The syntax for this function is relatively simple. However, we must look at several examples to understand how it works.
Example 1 – Round Down to Two Decimal Places
Let’s start with a single, straight-forward example of rounding the number 123.4567 to two decimal places:
=ROUNDDOWN(123.4567, 2)
This function will return the value of 123.45.
Example 2 – Round Down to Nearest Integer
You can also use the ROUNDDOWN function to round numbers down to the nearest integer. To do this, set the value for places to 0. For example, the following formula will round the number 345.678 down to the nearest integer:
=ROUNDDOWN(345.678, 0)
This example will return the value 345.
Example 3 – Round Down to Different Place Values
Now that we’ve seen a few examples to understand the basics, let’s try different values for the places argument using 456.78 every time. We’ll see different levels of rounding as a result.
Column C has no formatting applied, so only the ROUNDDOWN function drives the results.
Rows 2 and 3 have the same result even though the places arguments (3 and 2) are different. This difference is because Google Sheets only shows decimal places to the last significant digit unless you apply formatting to force the display of insignificant digits. Therefore, 456.78 in row 2 is only shown as 456.78 since the ending 0 does not impact the number’s value.
Google Sheets rounds the results in rows 4 and 5 to 1 and 0 decimal places, respectively. The 456.7 and the 456 are the new values, with decimal values discarded. If you change the formatting of column C to show more decimal values, they will be zeroes.
The negative values for places in rows 6 through 8 are removing significant digits. These results show that the ROUNDDOWN function can remove more than decimals if you use a negative number for the places argument. In the last row, the value is completely removed as all of the significant digits are rounded away. Be careful when using a negative number for the places argument, as the results differ by orders of magnitude.
Example 4 – Round a Negative Number
This function also rounds negative numbers. Let’s change the sign to negative and see what happens.
=ROUNDDOWN(-123.4567, 0)
This formula returns the value -123, which is different from the result provided by the INT function. Read more about the difference between INT and ROUND in Google Sheets.
Example 5 – Remove a Time from a Date
We can use the ROUNDDOWN function to eliminate the time from a date time. For example, let’s remove the 3 PM from 7/14/2025 3 PM.
=ROUNDDOWN(“7/14/2025 3 PM”,0)
The date comes out of the function correctly missing its time. However, the formatting can be inadvertently changed as well. This formula above outputs 45852 at first. However, changing the formatting to Date changes it back to 7/14/2025. If you know how dates and times work in a spreadsheet, you’ll realize these two outputs are equal. If you change the output formatting to Date time, you’ll see 7/14/2025 00:00:00.
Live Examples in Google Sheets
Make a copy of the spreadsheet with these examples.