Table of Contents

**Use Round Function in Google Sheets**

Learn how to round numbers in Google Sheets using the ROUND Function and its variations.

**Introduction**

Working with decimals can be tiresome. Data consisting of a lot of decimal numbers can be difficult to read and understand. This is where we can make use of the different variations of the ROUND Function to round numbers in Google Sheets to a number to either fewer decimal places or to the nearest integer.

Examples – 10.648 => 10.65 (Rounded to two decimals); 11.853 => 12 (Rounded to Integer).

In Google Sheets, you can also decide if you want to round up a number (nearest higher integer) or round it down (nearest lower integer). We will talk about all variations of Round formula in Google Sheets this article.

In general, using round numbers in Excel or Google Sheets is a great way to make your reports attractive as data is much easier to read.

**ROUND Function**

**Syntax**

ROUND(value, [places])

**value**: This is the numerical value that you want to round off.**[places]**: Refers to the number of places you want to round off to. This is an optional argument and takes a default value of 0. [places] can also be a negative number in which case value is rounded at the specified number of digits to the left of the decimal point.

**Example**

Let’s say we want to round off the number 23.67 to one decimal place. We can use the following formula to do so.

=ROUND(23.67,1)

I have demonstrated all the variations of the ROUND Function in Google Sheets in the spreadsheet shown below.

**ROUNDUP Function **

If you always want to round up a number to the next valid increment, then make use of the ROUNDUP Function.

**Syntax**

ROUNDUP(value,[places])

**value**: This is the numerical value that you want to round up.**[places]**: Refers to the number of places you want to round up to. This is an optional argument and takes a default value of 0. [places] can also be a negative number in which case value is rounded at the specified number of digits to the left of the decimal point.

**Example **

Hence to round up any number you can either pass the number or the cell reference as input to the ROUNDUP Function. Below mentioned is the formula I applied to round up the required numbers.

=ROUNDUP(23.67, 1)

Or

=ROUNDUP(A3, 1)

**ROUNDDOWN Function **

If you always want to round down a number to the next valid increment, then make use of the ROUNDDOWN Function.

**Syntax**

ROUNDDOWN(value,[places])

**value**: This is the numerical value that you want to round down.**[places]**: Refers to the number of places you want to round down to. This is an optional argument and takes a default value of 0. [places] can also be a negative number in which case value is rounded at the specified number of digits to the left of the decimal point.

**Example**

Similarly, the ROUNDDOWN function can also take the number or its cell reference as input to the function. The formula used is as follows

ROUNDDOWN(23.67,1)

Or

ROUNDDOWN(A3,1)

**MROUND Function **

MROUND Function is used in cases where you want to round your number to the nearest multiple of some *other *number, like 2, 3, 5, 7, etc. For example, an MRound applied to the number 434, with multiple 5, would yield an output of 435.

**Syntax**

MROUND(value,factor)

**value**: The numerical value that you want to round to the nearest integer multiple of another.**factor**: This is the number to whose multiple the value will be rounded. This argument can never take a negative value.

**Example**

The figure below clearly demonstrated all examples related to this function.

I have used the following formula to demonstrate the working of the MROUND Function.

=MROUND(323.67,2)

Or

=MROUND(A2,B2)

**Conclusion**

In this post, we looked at how to round numbers in Google Sheets using 4 different functions. You can use these functions accordingly when you want to round up, round down, or round a number to the nearest multiple of any other number.

**See More**

How to Use Countif Function in Google Sheets: Count the number of items basis a condition

How to Use SumIFs function in Google Sheets: Filter a range basis a condition and then find its sum total

How to Use AverageIFs function in Google Sheets: Filter a range basis a condition and then find its average