# ROUND

Rounds a number to the specified number of digits.

## Syntax

```
ROUND(<number>, <num_digits>)
```

### Parameters

Term | Definition |
---|---|

number | The number you want to round. |

num_digits | The number of digits to which you want to round. A negative value rounds digits to the left of the decimal point; a value of zero rounds to the nearest integer. |

## Return value

A decimal number.

## Remarks

If

**num_digits**is greater than 0 (zero), then number is rounded to the specified number of decimal places.If

**num_digits**is 0, the number is rounded to the nearest integer.If

**num_digits**is less than 0, the number is rounded to the left of the decimal point.Related functions

- 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 multiple of 0.5), use the MROUND function.
- Use the functions TRUNC and INT to obtain the integer portion of the number.

## Example 1

The following formula rounds 2.15 up, to one decimal place. The expected result is 2.2.

```
= ROUND(2.15,1)
```

## Example 2

The following formula rounds 21.5 to one decimal place to the left of the decimal point. The expected result is 20.

```
= ROUND(21.5,-1)
```

## Related content

## Feedback

https://aka.ms/ContentUserFeedback.

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for