The ROUNDUP function in Google Sheets rounds a number up to a specified number of decimal places. The function does not use standard rounding rules. Instead, it rounds all numbers up.
⚠️ The ROUNDUP 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 is still there; but you don’t see it. The unrounded value is permanently gone if you remove place values with this function.
Contents
Syntax
=ROUNDUP(value, [places])
value– The number that you want to round.places– Optional. The number of decimal places that you want to round to. If you don’t specify a place value, 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 Up to One Decimal Place
Let’s start with a straightforward example of rounding the number 12.34 up to one decimal place.
=ROUNDUP(12.34, 1)
This function will return the value of 12.4.
Example 2 – Round Up to the Next Integer
You can also use the ROUNDUP function to round numbers up to the next integer. To do this, set the value for places to 0. For example, the following formula will round the number 12.34 up to the next integer:
=ROUNDUP(12.34, 0)
This example will return the value 13.
Example 3 – Round Up 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 123.45 every time. We’ll see different levels of rounding as a result.
Column C has no formatting applied, so only the ROUNDUP 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 insignificant digits to show. Therefore, the 123.45 in row 2 is only shown as 123.45 as adding an 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 123.5 and the 124 are the new values, with the 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 ROUNDUP function can remove more than decimals if you use a negative number for the places argument. In the last two rows, the output is significantly higher than the inputs. Be careful when using a negative number for the places argument as the results can differ from the input by orders of magnitude.
Example 4 – Round a Negative Number
This function also rounds negative numbers. Let’s take the previous example and change the sign to negative.
=ROUNDUP(-123.4567, 0)
This formula returns the value -124, the same result the INT function provides. Read more about the difference between INT and ROUND in Google Sheets.
Live Examples in Google Sheets
Make a copy of the spreadsheet with these examples.