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