ROUND
TheROUND
formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If the places
parameter is not specified, the formula rounds to the nearest integer.
 How to use
ROUND
formula?  Examples of using
ROUND
formula ROUND
formula not working? Similar formulas to
ROUND
Usage
Use the ROUND
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value (required):
The number to be rounded.  places (optional):
The number of decimal places to round to. If omitted, the formula rounds to the nearest integer.
Examples
Here are a few example use cases that explain how to use theROUND
formula in Google Sheets.
Rounding to the nearest integer
Use ROUND
to round a number to the nearest integer. For example, if you have the number 3.6 in cell A1, you can use the formula =ROUND(A1)
to round it to 4.
Rounding to a specific number of decimal places
Use ROUND
to round a number to a specific number of decimal places. For example, if you have the number 3.14159 in cell A1, you can use the formula =ROUND(A1, 2)
to round it to 3.14.
Rounding negative numbers
Use ROUND
to round negative numbers. For example, if you have the number 3.6 in cell A1, you can use the formula =ROUND(A1)
to round it to 4.
Common Mistakes
ROUND
not working? Here are some common mistakes people make when using the ROUND
Google Sheets Formula:
Forgetting to include the value argument
One common mistake users make is forgetting to include the value argument in the ROUND formula. This will result in an error. To fix this, make sure to include the value argument.
Using a nonnumeric value for the value argument
Another common mistake users make is using a nonnumeric value for the value argument in the ROUND formula. This will result in an error. To fix this, make sure to use a numeric value for the value argument.
Using a noninteger value for the places argument
A mistake users make is using a noninteger value for the places argument in the ROUND formula. This will result in an error. To fix this, make sure to use an integer value for the places argument.
Using a negative value for the places argument
Another mistake users make is using a negative value for the places argument in the ROUND formula. This will result in an error. To fix this, make sure to use a positive value for the places argument.
Rounding to too many decimal places
A mistake users make is rounding to too many decimal places in the ROUND formula. This can result in inaccurate results. To fix this, make sure to use a reasonable number of decimal places.
Related Formulas
The following functions are similar to ROUND
or are often used with it in a formula:

CEILING
The
CEILING
function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments. 
FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.

MROUND
The
MROUND
function rounds a number to the nearest multiple of a specified factor. It is commonly used when dealing with financial data, such as currency or interest rate calculations. 
INT
The
INT
formula rounds a given value down to the nearest integer. This formula is often used to simplify large numbers or to convert decimal values to integers. The formula takes a single parameter, the value to be rounded down. If the value is already an integer, the formula will return the same value. If the value is a decimal, the formula will round down to the nearest integer. 
TRUNC
The
TRUNC
formula returns a number truncated to a specific number of decimal places. It is commonly used to remove decimal places from a number without rounding. This formula is often used in financial calculations and data analysis where exact values are important.
Learn More
You can learn more about the ROUND
Google Sheets function on Google Support.