# ROUND

The `ROUND` 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.

## Usage

Use the `ROUND` formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

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

Here are a few example use cases that explain how to use the `ROUND` 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 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.

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.

You can learn more about the `ROUND` Google Sheets function on Google Support.