## 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.

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.

## STEP1: Working With ROUND Function

Firstly, you need to enter the ROUND function:

=ROUND(

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,

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)

## 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.