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:

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the ROUND function:

=ROUND(

 

STEP 2: The ROUND arguments:

number

What is the number we want to round off?

Reference the cell that contains the number:

=ROUND(B9,

num_digits

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!

HELPFUL RESOURCE:

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Count Formula in Excel What does it do? Counts the number of cells that contain numbers Formula breakdown: =COUNT(value1, ...) What it means: =COUNT(range of cells to check, ...) Ever had a column of data and wanted to check if all of the values contain valid numbers? It would ...
CountBlank Formula in Excel What does it do? Counts the number of cells that are blank Formula breakdown: =COUNTBLANK(range) What it means: =COUNTBLANK(range of cells to check) Do you have a scenario where you want to count the number of cells that are blank in your Excel data? If y...
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...
Addition Formula in Excel What does it do? Adds two numbers Formula breakdown: =number1 + number2 What it means: =the number being added to + the number being added In Excel adding numbers together is really easy with the Addition Formula which uses the addition operator: + I will...