All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (2024)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (1)

If you have numbers in your Google spreadsheet that you need to round, this lesson will teach you all of the different ways to round numbers in a spreadsheet.

I will teach you how to round to the nearest whole number, how to round up or down to a specified decimal place, how to round to the nearest 10 or nearest 100, and more.

First we will go over how to use the ROUND function to round numbers according to traditional mathematical rules, where the formula decides to round up or down based on whether the next highest or the next lowest number is closer.

Then I'll show you how to use the ROUNDUP function to ensure that you round up, and then we'll go over how to use the ROUNDDOWN function to ensure that you round down.

When you see words like "tenth" and "hundredth" we are talking about decimal places (when there is a "th" at the end of the word.)

  • Hundreds: 100, 200, etc.
  • Tens: 10, 20, etc.
  • Whole numbers: 1, 2, etc.
  • Tenths (1 decimal place): 0.1, 0.2, etc.
  • Hundredths (2 decimals places): 0.01, 0.02, etc.

Positive vs. Negative decimal place criteria: If you use a positive number to specify the number of decimal place criteria in the ROUND / ROUNDUP / ROUNDDOWN function, this will specify how many decimal places to round to. If you use a negative number to specify the decimal place criteria, this will indicate multiples of 10 to round to.

  • 2 = 2 decimal places (hundredths)
  • 1 = 1 decimal place (tenths)
  • 0 = no decimals / whole number
  • -1 = tens
  • -2 = hundreds

Table of Contents

Using the ROUND function

First let's go over how to use the ROUND function, which will round according to the ordinary rounding rules, where the number will be rounded up if it is closer to the number above it, and the number will be rounded down if it is closer to the number below it. If the number is halfway between the number that is above and below it, the formula will round up.

With the round function, you simply specify the number to be rounded, and then specify the number of decimal places that you want to round to.

To round a number in Google Sheets, follow these steps:

  1. Type =ROUND( to begin the formula
  2. Type the number to be rounded, or the cell address that contains the number to be rounded
  3. Type a comma, and then enter a number to represent the number of decimal places to round to
  4. Press "Enter" on the keyboard. The final formula will look like this: =ROUND(A1,2)

After following the steps above, the number will be rounded according to normal rounding rules.

The Google Sheets ROUND function description:

Syntax:
ROUND(value, [places])

Formula summary: “Rounds a number to a certain number of decimal places according to standard rules.”

How to round to the nearest whole number

If you want to round to the nearest whole number, you can use the ROUND function without specifying the number of decimal places to round to, and by default the formula will round to the nearest whole number. Or you can specify "0" decimal places in the formula criteria. I will show you both of these formulas below.

Whole numbers are simply numbers without a decimal, like this: 1, 2, 3, 4, 5…

In this example, we have entered the number "1.5" into cell A2, and cell B2 rounds the number in cell A2 to the nearest whole number, with the formula below. Both of the formulas listed below do the same thing. The first formula does not specify the number of decimal places, and so the ROUND function defaults to zero decimal places. The second formula specifies zero decimal places, which yields the same result.

=ROUND(A2)

=ROUND(A2,0)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (2)

As you can see in the image above, cell B2 displays the number "2", after rounding the number in cell A2 (1.5) to the nearest whole number.

Since “1.5” is right in the middle of the numbers "1" and "2", the number was rounded up, which is the traditional rule when rounding a number that lies halfway between the next highest number and the next lowest number.

Rounding two decimal places to the nearest hundredth / cent

In this example, we are going to round to the nearest hundredth, which is the nearest cent when dealing with money/currency. This means that we will round to 2 decimal places.

Hundredths are increments like this: 0.01, 0.02, 0.03, 0.04, 0.05…

In this example, we have entered the number "1.577" into cell A2, and cell B2 rounds the number in cell A2 to 2 decimal places (nearest hundredth), with the formula below.

=ROUND(A2,2)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (3)

As you can see in the image above, cell B2 displays the number "1.58", after rounding the number in cell A2 (1.577) to 2 decimal places.

Since “1.577” is closer to "1.58" than it is to "1.57", the number was rounded up. If the number in cell A2 was "1.573", the formula would have rounded down to "1.57".

Round to the nearest tenth (1 decimal place)

To round to the nearest tenth in Google Sheets, round to one decimal place with the ROUND function, like this: =ROUND(A2,1)

For example, if the number "1.57" is entered into cell A2, then the formula below will round the number up to 1.6.

=ROUND(A2,1)

Since “1.57” is closer to "1.6" than it is to "1.5", the number will be rounded up. If the number in cell A2 was "1.53", the formula will round down to "1.5".

Rounding to the nearest ten

If you want, instead of rounding to a number of decimal places or to whole numbers, you can round in multiples of 10. In this example we will round to the nearest ten.

To do this, we will specify the number "-1" as the number of decimal places in the ROUND function.

Tens are increments like this: 10, 20, 30, 40, 50…

In this example, we have entered the number "7" into cell A2, and cell B2 rounds the number in cell A2 to the nearest multiple of ten, with the formula below.

=ROUND(A2,-1)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (4)

As you can see in the image above, cell B2 displays the number "10", after rounding the number in cell A2 (7) to the nearest ten.

Since “7” is closer to "10" than it is to "0", the number was rounded up. If the number in cell A2 was "3", the formula would have rounded down to "0".

Rounding to the nearest hundred

In this example, we are going to round to the nearest hundred.

Hundreds are increments like this: 100, 200, 300, 400, 500…

In this example, we have entered the number "77" into cell A2, and cell B2 rounds the number in cell A2 to the nearest multiple of hundred, with the formula below.

=ROUND(A2,-2)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (5)

As you can see in the image above, cell B2 displays the number "100", after rounding the number in cell A2 (77) to the nearest hundred.

Since “77” is closer to "100" than it is to "0", the number was rounded up. If the number in cell A2 was "33", the formula would have rounded down to "0".

Using the ROUNDUP function

Now let's use a different formula, which will always round up. The ROUNDUP function will round numbers to a specified number of decimal places, but the formula always rounds up to the nearest specified decimal place.

To round up in Google Sheets, follow these steps:

  1. Type =ROUNDUP( to begin the formula
  2. Type the number to be rounded up, or the cell address that contains the number to be rounded up
  3. Type a comma, and then enter a number to represent the number of decimal places to round up to
  4. Press "Enter" on the keyboard. The final formula will look like this: =ROUNDUP(A1,2)

The Google Sheets ROUNDUP function description:

Syntax:
ROUNDUP(value, [places])

Formula summary: “Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.”

Rounding up to the nearest whole number

In this example, we are going to round up to the nearest whole number. To do this we will use the ROUNDUP function, and we will specify zero decimal places, or you can leave out the decimal place criteria and the formula will default to rounding up to the nearest whole number.

In this example, we have entered the number "1.3" into cell A2, and cell B2 rounds the number in cell A2 up to the nearest whole number by using the formula below. Both of the formulas below do the same thing.

=ROUNDUP(A2)

=ROUNDUP(A2,0)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (6)

As you can see in the image above, cell B2 displays the number "2", after rounding the number in cell A2 (1.3) up to the nearest whole number.

Since "2" is the next whole number higher than "1.3", the number was rounded up to "2". Notice how the formula rounded up, even though "1.3" is closer to "1" than it is to "2", because the ROUNDUP function always rounds up.

Rounding up two decimal places to the nearest hundredth / cent

In this example, we are going to round up to the nearest hundredth, which means rounding up to the nearest cent when dealing with money/currency. This means that we will round up, to 2 decimal places.

In this example, we have entered the number "1.333" into cell A2, and cell B2 rounds the number in cell A2 up to 2 decimal places (nearest hundredth), with the formula below.

=ROUNDUP(A2,2)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (7)

As you can see in the image above, cell B2 displays the number "1.34", after rounding the number in cell A2 (1.333) up to 2 decimal places.

Since "1.34" is the next "hundredth" increment higher than "1.333", the number was rounded up to "1.34".

Using the ROUNDDOWN function

Now let's use a different formula, which will always round down. The ROUNDDOWN function will round numbers to a specified number of decimal places, but the formula always rounds down to the nearest specified decimal place.

To round down in Google Sheets, follow these steps:

  1. Type =ROUNDDOWN( to begin the formula
  2. Type the number to be rounded down, or the cell address that contains the number to be rounded down
  3. Type a comma, and then enter a number to represent the number of decimal places to round down to
  4. Press "Enter" on the keyboard. The final formula will look like this: =ROUNDDOWN(A1,2)

The Google Sheets ROUNDDOWN function description:

Syntax:
ROUNDDOWN(value, [places])

Formula summary: “Rounds a number to a certain number of decimal places, always rounding down to the next valid increment."

Rounding down to the nearest whole number

In this example, we are going to round down to the nearest whole number. To do this we will use the ROUNDDOWN function, and we will specify zero decimal places, or you can leave out the decimal place criteria and the formula will default to rounding down to the nearest whole number.

In this example, we have entered the number "1.7" into cell A2, and cell B2 rounds the number in cell A2 down to the nearest whole number by using the formula below. Both of the formulas below do the same thing.

=ROUNDDOWN(A2)

=ROUNDDOWN(A2,0)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (8)

As you can see in the image above, cell B2 displays the number "1", after rounding the number in cell A2 (1.7) down to the nearest whole number.

Since "1" is the next whole number lower than "1.7", the number was rounded down to "1". Notice how the formula rounded down, even though "1.7" is closer to "2" than it is to "1", because the ROUNDDOWN function always rounds down.

Rounding down two decimal places to the nearest hundredth / cent

In this example, we are going to round down to the nearest hundredth, which means rounding down to the nearest cent when dealing with money/currency. This means that we will round down, to 2 decimal places.

In this example, we have entered the number "1.119" into cell A2, and cell B2 rounds the number in cell A2 down to 2 decimal places (nearest hundredth), with the formula below.

=ROUNDDOWN(A2,2)

All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (9)

As you can see in the image above, cell B2 displays the number "1.110", after rounding the number in cell A2 (1.119) down to 2 decimal places.

Since "1.110" is the next whole number lower than "1.119", the number was rounded down to "1.110".

As you can see in the example, row 3 displays the same values in "Currency" format, so that you can see how the function works when dealing with currency / money.

You might have noticed that when you click the decrease decimal places button to remove decimal places from a number in your spreadsheet, although the cell displays fewer decimal places and the appears to be rounded, the actual number is still in the background, so if you want to round a number properly, use the instructions in this article to round numbers with formulas. But if you want a number to appear as being rounded while still keeping the exact number in the background, you can decrease decimal places.

Related Posts:

  • How to divide without a remainder in Google Sheets
  • How to increase and decrease decimal places in Google Sheets
  • 2 ways to convert decimals to fractions in Google Sheets
  • Tic Tac Toe Game Template for Google Sheets
  • 2 ways to format values as currency in Google Sheets
All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP) (2024)

FAQs

How do you round up all numbers in Google Sheets? ›

By default, the count argument is 0, which means the number will be rounded to the nearest whole number. To apply the ROUNDUP function, simply enter the formula into a cell and press Enter. For example, entering '=ROUNDUP(15.3)' will return 16.

What is the difference between round Roundup and Rounddown? ›

Round rounds up if the next digit is 5 or higher. Otherwise, this function rounds down. RoundDown always rounds down to the previous lower number, towards zero. RoundUp always rounds up to the next higher number, away from zero.

How do I round all numbers in a spreadsheet? ›

To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.

How to get 2 decimal places in Google Sheets? ›

For a quick adjustment of decimal places, users can utilize the toolbar buttons specifically designed for this task. After highlighting the desired cells, one can click on the “Increase decimal places” or “Decrease decimal places” buttons found in the toolbar.

How do I automatically round down in Google Sheets? ›

The ROUNDDOWN function always rounds the number down towards zero, regardless of the decimal portion of the number. For example, if you use the formula =ROUNDDOWN(3.14159, 2), it will round the number 3.14159 down to 2 decimal places. The resulting rounded number would be 3.14.

How to make a mround round up? ›

MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple. The Number and Multiple arguments must have the same sign.

What is the formula for rounddown? ›

The ROUNDDOWN function rounds a number down to a given number of places. The number of places is controlled by the number of digits provided in the second argument ( num_digits ). For example, these formulas round the number 5.89 down to 1 and zero places: =ROUNDDOWN(5.89,1) // returns 5.8 =...

How to create a round up formula? ›

Rules for calculating ROUNDUP in Excel

Here's how to write this function:=ROUNDUP(number, num_digits)In this formula, "ROUNDUP" is the command that lets Excel know you want it to make a calculation, "number" is the value you're rounding and "num_digits" is the number of decimal places you want the outcome to have.

How to use round formula? ›

For example, the function =ROUND(1234.4321,0) rounds the number to 1234. A positive num_digits argument (the argument is greater than 0) rounds the number to the specified number of decimal places. A positive num_digits argument rounds the number to the right of the decimal point.

What are the rounding options in Google Sheets? ›

To round numbers in Google Sheets, you can utilize various functions and formulas. One simple method is using the ROUND function. This function allows you to round a number to a specific number of decimal places. For example, “=ROUND(A2, 2)” will round the number in cell A2 to two decimal places.

How do you round averages in Google Sheets? ›

How to make numbers rounded in Google Sheets. The “Round” formula helps you get rounded numbers quickly. Type in “=ROUND(” or go to the “Insert” ➝ “Function” ➝ “Math” ➝ “ROUND”.

What is the 5 rule in rounding? ›

If the smallest place digit is greater than or equal to 5, then round up the digit. Since the digit in the smallest place is less than 5, a round down has to be done and also the digit remains unchanged. Every other digit becomes zero.

What is the golden rule for rounding numbers? ›

5 is the golden rule: 0,1,2,3,4 round down, and 5,6,7,8 and 9 round up.

Can you round numbers down? ›

If the number you are rounding is followed by 5, 6, 7, 8, or 9, round the number up. Example: 38 rounded to the nearest ten is 40. If the number you are rounding is followed by 0, 1, 2, 3, or 4, round the number down. Example: 33 rounded to the nearest ten is 30.

How do you round off numbers? ›

The general rule for rounding is as follows: If the number you're rounding has a 5, 6, 7, 8, or 9 after it, round it up. Example: 28 rounded to the nearest tens place equals 30. If the number you're rounding has a 0, 1, 2, 3, or 4 after it, round it down.

How to round up by 5 in Google Sheets? ›

Rounding to the nearest 5 or 10 in Google Sheets can be done by using the round function. The round function takes two arguments, the number to be rounded and the number of decimal places to which it should be rounded.

How do you do continuous numbers in Google Sheets? ›

Use autofill to complete a series

Highlight the cells. You'll see a small blue box in the lower right corner. Drag the blue box any number of cells down or across. If the cells form a series of dates or numbers, the series will continue across the selected cells.

How do I auto increment numbers in Google Sheets? ›

To use the AUTOINCREMENT function, type =AUTOINCREMENT(x) into the desired cell, where x is the starting number. Often you may want to automatically increment values in Google Sheets.

How do I apply a formula to an entire column in Google Sheets? ›

Grab the fill handle: Click the cell containing the formula, and locate the small blue square (fill handle) in the bottom-right corner of the cell. Drag the fill handle: Click and hold the fill handle, then drag it down to the last cell of the column where you want to apply the formula.

Top Articles
Latest Posts
Article information

Author: Nicola Considine CPA

Last Updated:

Views: 6613

Rating: 4.9 / 5 (69 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Nicola Considine CPA

Birthday: 1993-02-26

Address: 3809 Clinton Inlet, East Aleisha, UT 46318-2392

Phone: +2681424145499

Job: Government Technician

Hobby: Calligraphy, Lego building, Worldbuilding, Shooting, Bird watching, Shopping, Cooking

Introduction: My name is Nicola Considine CPA, I am a determined, witty, powerful, brainy, open, smiling, proud person who loves writing and wants to share my knowledge and understanding with you.