# ROUNDUP Function – Google Sheets

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.

## 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 is `0`.

## Similar Functions

Several functions deal with rounding. Choose the most appropriate for your use.

• CEILING – Rounds a number up to the nearest integer multiple of specified significance
• INT – Rounds a number down to the nearest integer
• FLOOR – Rounds a number down to the nearest integer multiple of specified significance
• MROUND – Rounds one number to the nearest integer multiple of another
• ROUND – Round 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

## 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 Two Decimal Places

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.