Anyone who works with figures in Microsoft® Excel® knows the importance of quickly rounding off numbers. Luckily Excel has an easy function that allows you to round off numbers without any hassle.
Instead of clicking the increase or decrease decimal options on the ribbon, you can use the ROUND function to round off numbers to a specified number of decimal digits.
In the next tip we will explain how to round off seconds to minutes using the MROUND function.
Note: You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® 2010 and 2013.
- Place the cursor in cell B2.
- Type =ROUND(A2,2) and press enter.
- A2 is the cell reference for the number you want to round.
- 2 is the number of digits to which you want to round.
- Negative rounds to the left of the decimal point and zero to the nearest integer.
- Copy down the formula.
As you can see the numbers have been rounded off to 2 digits with an easy formula, thus saving you time and making your process more efficient.