Introduction

The Microsoft Excel ROUND function allows you to round a numeric values making the number simpler but having its value close to what it was originally.

This function is categorized under Math/Trig Function in Excel. In this article, you will learn how to use Excel Round function.

The Round Formula in Excel Parameters and Arguments:

Number – The number which has to be rounded.

Num_Digits – The total number of digits to round the number to.

Microsoft Excel Round Function

In Excel, the Round function works by rounding the numbers 1-4 down and rounding the numbers 5-9 up. It can be used for rounding to the nearest right or nearest left of the decimal point.

Uses of Num_Digits

When num_digits is greater than 0, the number will be rounded to the specified decimal places to the right of the decimal point.

=ROUND (18.55, 1) will round 18.55 to 18.6.  

When num_digits is less than 0, it will be rounded to the left of the decimal point (to the nearest 10, 100, 1000..).

=ROUND (18.55, -1) will round 18.55 to the nearest 10 and return 20 as the result.

When num_digits = 0, the number will be rounded to the nearest integer, there are no decimal places.

=ROUND (18.55, 0) will round 18.55 to 19.  
=ROUND(33.5,0) will round 33.5 to 34  

Excel ROUNDUP Function

The ROUNDUP function will always round numbers up. The number of places to round to is controlled by the num_digits

Positive numbers round to the right of the decimal point and negative numbers round to the left. Lastly, zero rounds to the nearest 1

To round the values up to the right of the decimal point, use a positive number for digits

Here are the examples:

Round up to nearest .1, .01, .001, .0001 and so on for >0  
Round up to nearest 10, 100, 1000, 10000 and so on for <0  
and Round up to nearest 1 for =0  

ROUNDDOWN Function in Excel

The ROUNDDOWN function is same as RoundUp except that it rounds a number down.

Here are examples:

Round to Right

=ROUNDDOWN(A2,1) // Round down to 1 decimal place  

=ROUNDDOWN(A2,2)// Round down to 2 decimal place  

=ROUNDDOWN(A2,3)// Round down to 3 decimal places  

Round to Left

=ROUNDDOWN(A2,0) // Round down to nearest whole number  
=ROUNDDOWN (A2,-1) // Round down to nearest 10  
=ROUNDDOWN (A2,-2) // Round down to nearest 100  

MROUND Function in Excel

The Excel MROUND function always rounds numbers to a specified multiple.

MROUND will round a number up or down, depending on the nearest multiple. When a number is an exact digit, no rounding will be done and the same number is returned. Here are some examples:

Round to Nearest 5

=MROUND(A2,5) - to the nearest multiple of 5  

Round Pricing to Nearest .99

=MROUND(A2,1) - 0.01 round to the nearest .99  

Round Time to Nearest 15 Minutes

=MROUND(A2, "0:15") - round to the nearest 15 mins  

Conclusion

Having this Round Functions in excel allows users to perform simple calculations and very useful in more complex mathematical calculations. This is a great tool to utilize to simplify some numeric values in your worksheets to make it easier to digest. We hope you can use some of the rounding functions we discussed here to help simplify your worksheets.