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 FormulasHow to Extract First Name from Full Name in Excel?

ROUND Formula breakdown:

=ROUND(number, num_digits)

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:

=ROUND(

Round Off Numbers with Excel’s ROUND Formula

Continue with the ROUND arguments:

Number

In the place of ‘Number’ write the number you need to round off?

Mention the cell that contains the number:

=ROUND(A2,

Round Off Numbers with Excel’s ROUND Formula

num_digits

now at the place of ‘num_digits’ write the round off to how many digits?

Mention the cell that contains the number of digits:

=ROUND(A2,B2)

Round Off Numbers with Excel’s ROUND Formula

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. 

Round Off Numbers with Excel’s ROUND Formula