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 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

## 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 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.