ROUND

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

=ROUND(value, [places])

1. value (required):
   The number to be rounded.
2. places (optional):
   The number of decimal places to round to. If omitted, the formula rounds to the nearest integer.

Examples

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

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 non-numeric value for the value argument

Another common mistake users make is using a non-numeric 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 non-integer value for the places argument

A mistake users make is using a non-integer 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.