Microsoft Excel is not merely a spreadsheet software; it also provides users with the tools to perform various complex mathematical operations.
One of the mathematical tasks which can be performed is that one can round off decimal values in MS Excel, not only that, you can round off decimal values in whichever way you want, through the various options which are provided by the software.
You can streamline your numerical data using the ROUND functions. Within it, there are ROUND, ROUNDUP, and ROUNDDOWN sub-functions.
When you want to round off a number to a specific decimal place, you use the ROUND function. It will round down the number if the digit in the next decimal to the right is between 0 and 4.
Same way, it will round up if the digit in the next decimal to the right is between 5 and 9. In short, it will round up to the decimal place that you configure. For example, if you want to round up 9.53 to one decimal place, it will be 9.5.
Similarly, if you round up 4.567 to two decimal places, you will get 4.57. It can round the number either to the right or left to the decimal point.
To access the ROUND function on Excel, follow the following steps.
- 1Go to the ‘Formulas’ menu on the ribbon on the top
- 2After selecting, ‘Formulas’, click the ‘Math and Trig’ option in the drop-down menu
- 3Click the ‘ROUND’ function on the ‘Math and Trig’ drop-down menu
- 4This will open the ‘Functions Arguments’ window, which contains the fields which you will use for computing with the ROUND function.
Then type the number that you want to round off on the “Number” field. You can type the number straight upon the number field, but usually, the number is taken from an existing cell.
For example, if you want to round off a number in the C5 cell, you type C5 on the ‘Number’ field.
Then you have the "Num_Digits" field to specify the number of decimal places the number has to be rounded up to. For example, if you want to round off 2.555 to one decimal, you will type 1 in the “Num_Digits” column. You will get the value 2.6.
In the ‘Num_Digits’ field all the three types of integers can be entered. All of them have different functions as explained below:
Along with this, you can also use the function bar to perform this function if you like. For this you have to:
- 1Click on the function bar to activate it.
- 2Then type in the formula using this method: =ROUND(number, num_digits), where the ‘number’ is the number being computed and the ‘num_digits’ is the digit to which the computed number will be rounded off to.
For example, if you want to round off a number on the F7 cell to 3 places after the decimal point, you type, ROUND(F7,3) on the function bar. You will get the value.
Same way, you can compute other values also, such as:
You can also round off negative numbers using this method. For example, rounding up -33.63 to one decimal place will get you -33.6.
Round Numbers in Excel with Round Function
Sometimes, you just want to round up the numbers, meaning that you want to increase the value of the number that you want to round off. For this, you need to use the ROUNDUP function. For this,
- 1Head to the ‘Formulas’ menu on the ribbon on the top.
- 2After clicking it, select the ‘Math and Trig’ option.
- 3After that, click ROUNDUP on the drop-down box
After clicking it, as in the case with the ROUND option, the "Functions Arguments" window will open. You then have to type the number or the cell you want to compute, in the ‘Number’ field and decimal place to which you want to round up to on the ‘Num_digits’ field. For example, you can type 4.45 on the ‘Number’ field and 1 on the ‘Num_digits’ field, and you will get 4.5 as the answer.
You can also use the function bar to round up the numbers. You will need to type in the following syntax,
You can also perform this operation on negative numbers.
How to ROUNDUP in Excel
When you want to round down a number, i.e. decrease the value of the number while rounding off, you use the ROUNDDOWN option.
To perform this function, follow the same steps as used for the ROUNDUP function and click the ROUNDDOWN option on the drop-down box.
You will get the “Functions Arguments” window where you will need to type the number in the ‘Number’ field and the number of decimal places to be rounded down to in the ‘Num_digits’ field. For example, 4.546 rounded down to the 2 decimal places will be 4.54.
You can also perform this function using the Function Bar on the top. You need to use the following syntax:
For example, If you want to round down a number on the B7 to one decimal point, you have to do the following, ROUNDDOWN(B7,1). You will get the answer. The other examples are as follows:
The other operations that can be performed using more functionalities are as follows:
- 1MROUND FUNCTION: It will round off a number to the nearest specified multiple. E.g., if the number is 10, and the specified multiple is 3, then the answer will be 9. The syntax for this function is MROUND (number, multiple).
- 2CEILING FUNCTION: It will round up a number to the nearest specified multiple. E.g., if the number is 10, and the specified number is 3, then the answer will be 12. The Syntax for this function is CEILING (number, multiple). It works like the MROUND function, but it will always round up.
- 3FLOOR FUNCTION: It will round down a number to the nearest specified multiple. E.g., if the number is 20, and the multiple is 3, then the resultant number will be 18. The Syntax for this function is FLOOR (number, multiple). It works like the MROUND function, but it will always round down
How to Round Down in Excel
These are some of the functions which you can use for rounding off a number. Along with these, various other functions and formulas are also available to aid you in any computation you perform in MS Excel. You just need to know which one to use and how to use it. The Sky's the limit as far as MS Excel is concerned.