## 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

### Return value

A rounded number

### Arguments

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

### Remarks

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

### 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.