Round Off Numbers with Excel’s ROUND Formula
It will help you to round a number to the nearest decimal that will be based on your specified number of digits in Excel.
Previously In Excel Formulas: How to Extract First Name from Full Name in Excel?
ROUND Formula breakdown:
An explanation for this:
=ROUND(the number, number of decimal places to round off)
If you have ever wanted to round off the numbers? In financial calculations many people need it.
For example, if you need to calculate percentage discounts and it gives you a number such as 64.4189349, rounding it off to 64.40 so, round off to 1 decimal place makes it more presentable!
It’s very easy to do this in Excel with the ROUND formula.
Here are the steps to follow in your Excel:
STEP1: Working With ROUND Function
Firstly, you need to enter the ROUND function:
Continue with the ROUND arguments:
In the place of ‘Number’ write the number you need to round off?
Mention the cell that contains the number:
now at the place of ‘num_digits’ write the round off to how many digits?
Mention the cell that contains the number of digits:
STEP2: Applying To ALL
By dragging the ROUND formula all the way down using the left mouse button, apply the same formula to the rest of the cells.
Now you will be able to round off with different number of places in your Excel.