# ROUND function

The ROUND function in Excel is a useful mathematical function that allows you to round a number to a specified number of decimal places. This function can be handy in various situations, from financial calculations to data analysis, where you need to simplify or approximate numbers for better readability or accuracy.

## Syntax

ROUND(number, num_digits)

## How to Use

The ROUND function is quite straightforward to use. You simply provide it with the number you want to round and the number of decimal places to which you want to round it. Here are some examples:

This formula would round the number 3.14159 to 2 decimal places, resulting in 3.14.

Here, the number 1234.5678 is rounded to the nearest ten, resulting in 1230.

This formula rounds 987.654 to the nearest hundred, giving you 1000.

Remember, if you want to round to a specific number of decimal places, use a positive value for num_digits. If you want to round to the nearest multiple of 10, 100, etc., use a negative value for num_digits.

## Examples

Let’s look at a few more examples to understand the ROUND function better:

Rounding to 0 decimal places gives 6.

Rounding to 3 decimal places results in 123.457.

Rounding to the nearest thousand gives 10000.