# Excel ROUND Function and Formula with Examples

## How to Use the ROUND Function and Formula in Excel

In this tutorial, you'll learn how to use the ROUND function and formula in Excel.

The ROUND() function rounds a number to a specified number of digits.

### Excel ROUND Syntax

The syntax of the ROUND() function is as follows:

=ROUND(number, num_digits)

A rounded number

### Arguments

• number: The number that you want to round.
• num_digits: The number of digits that you want to round the number

### Remarks

• If num_digits is set to 0, then the number is rounded to the nearest integer.
• If num_digits is less than 0, then the number is rounded to the left of the decimal point.
• If it is greater than 0, then the number is rounded to the specified number of decimal places.

### Excel ROUND Example

#### Example 1: Round a Number to 1 decimal place

The following example rounds a number to one decimal place:

=ROUND(45.2515,1)

ROUND() rounds 45.2515 to one decimal place and returns 45.3.

Another example:

=ROUND(45.2616,1)

ROUND() rounds 45.2616 to one decimal place and returns 45.3.

As you can see, the numbers 45.2515 and 45.2616 are different. But, both formulas return the same rounded number.

#### Example 2: Round a number to 2 decimal places

The following example rounds a number to two decimal places:

=ROUND(45.2516,2)

ROUND() rounds 45.2516 to two decimal places and returns 45.25.

Another example:

=ROUND(45.2616,2)

ROUND() rounds 45.2616 to two decimal places and returns 45.26.

As you can see, when you round 45.2516 and 45.2616 to two decimal places, both formulas return different rounded numbers.

##### Example 3: Round a number to the nearest integer

The following formulas round the number to the nearest integer:

=ROUND(45.2515,0)

ROUND() rounds 45.2515 to the nearest integer and returns 45.

Another example:

=ROUND(45.9192,0)

ROUND() rounds 45.9192 to the nearest integer and returns 46.

##### Example 4: Round a number to 1 decimal place to the left of the decimal points

The following example rounds a number to one decimal place to the left of the decimal points:

=ROUND(648.31,-1)

The above formula returns 650.

##### Example 5: Round a number to the nearest multiple of 100

The following example round 648.31 to the nearest multiple of 100:

=ROUND(648.31,-2)

The above formula returns 600.

##### Example 6: Round a number to the nearest multiple of 1000

The following formula rounds 648.31 to the nearest multiple of 1000:

=ROUND(648.31,-3)

The above formula returns 1000.

Let's change num_digit from 3 to 4, as the following example shows:

=ROUND(648.31,-4)

The above formula returns 0.

#### Example 7: Round a number to the nearest multiple of 5

The simplest way to round to round a number to the nearest five is to use the MROUND() function.

Here are examples:

=MROUND(100, 5) = 100

=MROUND(102, 5) = 100

=MROUND(103, 5) = 105

=MROUND(108, 5) = 110

=MROUND(109, 5) = 110

Or you can use the ROUND function, as the following examples show:

=ROUND(102/5, 0) * 5 = 100

=ROUND(103/5, 0) * 5 = 105

=ROUND(103/5, 0) * 5 = 105

=ROUND(108/5, 0) * 5 = 110

=ROUND(109/5, 0) * 5 = 110

#### Example 8: Round a number to the nearest multiple of 10

Similarly, to round a number to the nearest multiple of 10, you can use the MDROUND() or ROUND() function, as the following examples show:

=MROUND(24,10) or =ROUND(24/10, 0) * 10 = 20

=MROUND(25,10) or =ROUND(25/10, 0) * 10 = 30

If you want to round up (away from zero), then use the ROUNDUP function.

If you want to round down (toward zero), then use the ROUNDDOWN function.

In this tutorial, you've learned how to use the Excel ROUND function

ROUND() is a function to round numbers to a specified number of digits.