ROUNDUP Function in Google Sheets

ROUNDUP Function belongs to the family of Mathematical functions in Google Sheet used for rounding numbers.

It’s very similar to ROUND Function, just with the difference that it will always Round-up. Let’s go through the salient features of ROUNDUP Function in this tutorial.

Purpose of ROUNDUP Function

As you would have guessed, it helps us to round numbers and retain decimals upto a specified decimal place.

One important callout for ROUNDUP is that it always picks the higher value while rounding off. This means”

ROUNDUP(32.76,1) equals 32.8

and

FLOOR(32.73, 1) equals 32.8

Before jumping onto examples let’s understand the syntax of ROUNDUP.

Syntax and Parameter Definition

= ROUNDUP(value, [places])
  1. value: The number you want to round
  2. [places]: The number of decimal digits you want to round the ‘value’ to.

Note:

  1. Value can take only numerical input
  2. Any form of non-numerical input(like “abc”, “xyz” etc) for value will result in an “#VALUE!” error.
  3. [places] is an optional input. 0 is it’s default value.
  4. [places] should be an integer either positive or negative.
  5. You can directly add static values or cell references for both value and [places]

Expected Output, logic behind it and Examples

ROUNDUP function follows a very simple logic to operate.

Say, you want to round up to 2 decimal places. ROUNDUP will retain the number upto two decimal place and increase the last decimal digit by 1.

Simplest Case – ROUNDUP Function

Below shown example is a very simple example of how ROUNDUP works and where is it different from ROUND Function.

ROUNDUP Function Definition - Example

As you may have observed in both the cases ROUNDUP Function returns an output with a one decimal place and higher than original Value. ROUND, on the other hand would not have rounded the first case since it follows the strict rule of the next decimal place digit to be >5 before rounding up the number.

More Examples – ROUNDUP Function

In the below example we have taken the liberty to play around with Places. Let’s discuss the insights we can derive from the below.

In, the first three case we have varied the [places] keeping Value same. The outputs are pretty self explanatory as well. In all cases ROUNDUP has increased the last decimal digit by 1.

In the last two cases, we kept places as 0/missing. Not surprisingly, the results are same as default value of [places] if not supplied is 0. Having [places] as 0, gives an indication to ROUNDUP that we don’t need any decimal value, hence the result it a whole number.

Working with Negative ‘Value’

We used the same cases from last example, just added a minus sign before it. Clearly, there’s no effect to working of Roundup Function. The output we got last time is intact this time as well.

Negative Values in ROUNDUP Function

Working with Negative ‘Places’

Having Negative value in ‘Places’ results in rounding up to nearest Ten’s/Hundred’s/Thousand’s depending on the value of Places(-1/-2/-3 and so on)

Negative Places in ROUNDUP Function

Visual Demo of ROUNDUP Function

Before we end here is a sample visual demonstration of ROUNDUP Function in action.

That’s it on this topic. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply