**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**:

## =ROUND(

**STEP 2:** The ROUND arguments:

**number**

**number**

**What is the number we want to round off?**

*Reference the cell that contains the number:*

## =ROUND(B9,

**num_digits**

**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: