Chinmoy Mondol
Excel works tremendously well especially regarding mathematical calculations. It has a large number of built-in functions which helps to do complicated mathematical functions quite easily. One frequently used mathematical calculation is to Round Off Numbers which can be done by several methods in Excel. In this article we will show 10 simple methods to round off numbers in Excel.
Download Practice Workbook
You can download the practice workbook from here.
10 Easy Methods to Round Off Numbers in Excel
We made a dataset to Round Off Numbers which includes some items and their price having 3 decimal values. We will round the price value with 10 simple and easy methods.
Method 1: Round Off Numbers Using ROUND Function
We can use the ROUND Function of Excel to round the number. Let’s follow the steps given below.
- First, select cell D5 and write the following formula there.
=ROUND(C5,2)- Next, hit Enter.
- Then, use Fill Handle to copy the formula in the cells below.
Read More: How to Add ROUND Formula to Multiple Cells in Excel (2 Easy Ways)
Method 2: Apply ROUNDUP Function in Excel
The ROUNDUP function of Excel can be used also which rounds a number by increasing the decimal value. Let’s follow the steps given below to use the function for rounding off numbers.
- First, select cell D5.
- After that, write the following formula in the cell
=ROUNDUP(C5,1)- Next, hit Enter.
- Finally, use Fill Handle to copy the formula in the cells below.
Read More: How to Roundup a Formula Result in Excel (4 Easy Methods)
Method 3: Number Rounding with ROUNDDOWN Function
The ROUNDDOWN function can also be used to round down numbers. The function decreases the decimal value according to the argument given. We are showing the steps below to round off numbers using the ROUNDDOWN function.
- Let’s select cell D5 first.
- Then, write the following formula in the cell.
=ROUNDDOWN(C5,1)
- Next, press Enter.
- Later on, use Fill Handle to copy the formula in the cells beneath.
Read More: How to Round Down to Nearest Whole Number in Excel (4 Methods)
Method 4: Excel MROUND Function to Round Off Numbers
Excel has the MROUND function which can also round numbers. Let’s follow the steps given below to round a number in Excel.
- Firstly, select cell D5 and write the following formula in the cell
=MROUND(C5,1)- Now, press Enter.
- Finally, use the AutoFill option to copy the formula in the following cells.
Read More: Round to Nearest Whole Number in Excel (9 Easy Methods)
Method 5: Make Use of FLOOR Function in Excel
We can use the FLOOR function of Excel to round numbers. The FLOOR function rounds the number as a multiple of another number which is given in argument. We are showing the steps to use this function to round off numbers.
- First, select cell E5 and write the formula given below.
=FLOOR(C5,D5)- Now, hit Enter.
- Finally, use the Fill Handle to copy the formula in the following cells.
Read More: How to Round Off to Nearest 50 Cents in Excel (4 Quick Methods)
Method 6: Insert CEILING Function for Rounding Off Numbers
The CEILING function also works similar to the FLOOR function but it gets the nearest upper multiple of a number of significance which is given in the argument. The steps to use the CEILING function for rounding off numbers are given below.
- At the starting, select cell E5 and write the following formula there.
=CEILING(C5,D5)- Then, hit Enter.
- Next, use the AutoFill option to copy the formula in the cells following.
- Finally, we can see the round off price in the range of cells E5:E10.
Similar Readings
- How to Stop Rounding in Excel (5 Handy Ways)
- Round Down to Nearest 10 in Excel (3 Effective Ways)
- How to Round Time to Nearest Minute in Excel (5 Suitable Ways)
- Rounding Time to Nearest Quarter Hour in Excel (6 Easy Methods)
- How to Set Rounding Precision in Excel (with Easy Steps)
Method 7: Application of INT Function in Excel
The INT function of Excel also rounds off a number just fine. This function discards the decimal value of a number and gives the integer value as output. The steps to use the function to round off numbers are given below.
- Select cell D5 and write down the formula given below.
=INT(C5)- Further, press Enter.
- Lastly, use the Fill Handle to copy the formula in the following cells.
Read More: How to Remove Decimals in Excel with Rounding (10 Easy Methods)
Method 8: Excel EVEN & ODD Functions to Round Off Numbers
We can also use the EVEN function and the ODD function to round off numbers. The ODD function takes a number and increases its value to the nearest odd number whereas the EVEN function increases the number up to the nearest even number. The steps to use these functions to round off numbers are given below.
For ODD Function
- First, select cell D5 and write the formula given below in the cell.
=ODD(C5)- Next, hit Enter.
- Further, use the Fill Handle to copy the formula in the following cells.
For EVEN Function
- First, select cell E5.
- Next, write the following formula in the cell.
=EVEN(C5)- Then, press Enter.
- Finally, use the AutoFill option to copy the formula in the following cells.
Read More: How to Round Time to Nearest 15 Minutes in Excel (6 Quick Methods)
Method 9: Use TRUNC Function for Rounding Numbers
The TRUNC function works just fine to round off numbers in Excel. In the following section we will discuss the steps to use the TRUNC function to round off numbers.
- Select cell D5.
- Next, write the formula given below.
=TRUNC(C5,2)- Then, hit Enter.
- Further, use the Fill Handle to copy the formula in the cells below.
Method 10: Apply Functions from Math & Trig Option
So far we wrote down the functions in the formula for every method. There’s a different way to use the functions. We are showing the procedure stepwise below to round off numbers in Excel.
- First, select the cell where we want to write the formula.
- Now, go to the Formulas tab in the ribbon and select Math & Trig.
- After that, we will see a list of functions in the drop-down. We choose the ROUND function from the list.
- Consequently, the Function Argument box will appear.
- In the Number section, we select cell C5 as we want its number to round off and in Num_digits section we give the number up to which the function will keep the decimal.
- Next, press OK.
- Further, use the Fill Handle to copy the formula in the following cells.
- Finally, we can see the round off prices in all cells in the range D5:D10.
How to Round Off Negative Numbers in Excel
We can also round off negative numbers in Excel. The method is quite similar. We created a dataset which has some negative numbers. The procedure to round off negative numbers is described below stepwise.
- First, select cell C5.
- Next, write the following formula there.
=ROUND(B5,2)- Then, press Enter.
- Afterwards, use the AutoFill option to copy the formula in the cells below.
- Bravo! We have successfully rounded the negative numbers in Excel.
Read More: How to Stop Excel from Rounding Up Decimals (4 Easy Methods)
Conclusion
It’s quite simple to round off numbers in Excel and we can do it using several methods. In this article we have shown 10 such easy and simple methods to round off numbers in Excel. If you have any queries or suggestions, please let us know by commenting. Please visit our ExcelDemy site for more articles about Excel.
Related Articles
- How to Round Time in Excel (With 3 Examples)
- Rounding Time in Excel to Nearest Hour (6 Easy Methods)
- How to Round a Formula with SUM in Excel (4 Simple Ways)
- Stop Excel from Rounding Large Numbers (3 Easy Methods)
- How to Round Excel Data to Make Summations Correct (7 Easy Methods)
- Use DOLLAR Function in Excel (5 Suitable Examples)
- How to Calculate Accuracy and Precision in Excel
