course bg
EduPristine>Blog>Using Rounding functions in Excel

Using Rounding functions in Excel

March 7, 2015

Math has always been complicated and the decimal places made it worst. As kids, I am sure that all the students hated when the numbers appeared with decimal points. Well the story has not changed much; we still hate data with decimal points. But now with Rounding functions of Excel, they don’t seem that difficult. So to make your life also a little easier, we bring you an article that will help you to use the rounding functions easily.

Through this article you can learn using:

  • Round function
  • Round up function
  • Round down function

Round Function

Round function helps you to round a specific number to the desired decimal places. Remember that 1, 2, 3, 4 shall be rounded down whereas 5, 6, 7, 8, 9 shall be rounded up.

Syntax for ROUND function is

ROUND(number, num_digits) wherein

number The number that you want to round.

num_digits The number of digits to which you want to round the number argument.

Using ROUND function

1.  In our example below, we have data having 3 decimal places and we shall round it to 1 decimal using the Round function.

Round function in Excel

2.  In the formula you can either use the number or give a cell reference (cell reference in our case) and in num_digits you have to mention the number of decimal places you require ( 1 in our case )

rounding numbers in Excel

3.  Press enter and your number will be rounded off.

Using Round function in Excel

4.  Drag the fill handle or double click and you will see that all your cells have been rounded off.

using fill handle in Excel’s round function

RoundUp function

ROUNDUP function rounds the number up that is away from zero.

Syntax for ROUND function is

ROUNDUP(number, num_digits) wherein

number The number that you want to round.

num_digits The number of digits to which you want to round the number argument.

Using ROUNDUP function

1.  In the similar example above we shall use the ROUNDUP function. The values in the formula remains the same as we are using the same example and same number digits

Using Roundup function in Excel

2.  After pressing enter and dragging the fill handle, you will see that your data is rounded up. You will notice that even though some numbers (marked red) have decimal value below 5, they are rounded up to a higher value.

difference between round and round up function

ROUNDDOWN function

ROUNDDOWN function rounds the number down, which is towards zero.

Syntax for ROUND function is

ROUNDDOWN(number, num_digits) wherein

number The number that you want to round.

num_digits The number of digits to which you want to round the number argument.

Using ROUNDDOWN function

1.  In the same example, we shall now use the ROUNDDOWN function. Again, the values in the formula shall remain same.

Using Rounddown function in Excel

2.  After pressing enter and dragging the fill handle, you will see that your data is rounded down. You will notice that even though some numbers (marked red) have decimal value above 5, they are rounded down to a lower value.

Difference between Round, Roundup and Rounddown function in Excel

Rounding the number to the nearest 10

When you want to round off the number to the nearest 10, then use -1 in the num_digits and your cell will be rounded off as shown in the image below.

rounding number to the nearest 10 in excel

Rounding number to the nearest 100

When you want to round off the number to the nearest 100, then use -2 in the num_digits and your cell will be rounded off as shown in the image below.

rounding number to the nearest 10 in excel

Similarly, you can round off numbers to the nearest 1000, 100000 etc by using -3, -4 and so on.

If you have any suggestions or queries, mention them in the comments box below.

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 72183