What does it do?

Rounds a number to the nearest decimal based on your specified number of digits

Formula breakdown:

=ROUND(number, num_digits)

What it means:

=ROUND(the number, number of decimal places to round off)

Ever had the need to round off numbers?

I do it all the time in my financial calculations.  For example, if I need to calculate percentage discounts and it gives me a number such as $47.4189349, rounding it off to $47.40 (round off to 1 decimal place) makes it so much more presentable!

In Excel, it’s very easy to do that with the ROUND formula!

I explain how you can do this below:


STEP 1: We need to enter the ROUND function:



STEP 2: The ROUND arguments:


What is the number we want to round off?

Reference the cell that contains the number:



Round off to how many digits?

Reference the cell that contains the number of digits:

=ROUND(B9, C9)


STEP 3: Do the same for the rest of the cells by dragging the ROUND formula all the way down using the left mouse button.

Now you are able to round off with different number of places!


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Calculate the Compound Interest with Excel’s... What does it do?Calculates the compound interestFormula breakdown:=FV(rate, nper, pmt, )What it means:=FV(interest rate, number of periods, periodic payment, initial amount)Say that you turn 18 years today (CONGRATS!) and you find out that your parents...
Get the Average of Values with Excel’s AVERA... What does it do?Gives you the average of a group of valuesFormula breakdown:=AVERAGE(number1, number2...)What it means:=AVERAGE(the numbers you want to average) There are times when you have to get the average of your values in your Excel work...
10 + 1 Ways to Round Numbers in Excel This is a guest post by Alan Murray from Computergaga.There are many ways to round numbers in Excel. These techniques will typically involve formatting the values, or using formulas.This post will look at 10 rounding functions of Excel, and then look at some formatting te...
VLOOKUP with Multiple Criteria in Excel ‘VLOOKUP’ is now so common that everyone who has ever been working with Excel has heard of it. Not necessarily because they know how to use it, but because some savvy Excel-user always talks about it at the office.Advanced users have seen the use of adding more than one...