Let’s face it; it’s all fun and games when you are playing with the numbers, but as soon as the decimals start to make an appearance, things start to take a turn.
But it doesn’t necessarily have to be that way.
With applications like Microsoft Excel at your disposal, handling the decimals has never been this easy.
For someone in data analysis, the importance of finding an easier way to deal with the decimals can never be lost. If you identify yourself as one such individual, then you have surely landed on the right page.
One of the primary adjustments that you are likely to make on a number with a decimal point is rounding in excel.
Considering that Microsoft Excel is entirely focused on automating the processes, you can bet that it has a trick up its sleeve that can help you round a number with a decimal point with ease and efficiency.
Such is the very aim of this tutorial.
Read along and find out the three major functions namely excel round, excel roundup, and excel rounddown, and learn how they can help you in rounding a number.
How To Round Numbers In Excel
Suppose that you have a number at your disposal that has 4 or even 5 digits after the decimal. You wish to round this number up to 2 digits after the decimal. You can follow these steps to use excel round function for such a task.
- Launch Microsoft Excel on your device. Click on “Create New Sheet” to open a new spreadsheet in which you can enter the data of your choice.
- Click on any given cell. You can double click on the cell to be able to enter your numeric value in it.
- Suppose that the cell you have chosen is cell A2. Type a numeric value of 4 or 5 digits after the decimal point in this cell. In this example, we’re going to assume that the value you typed in was “125.48293”.
- Now click on a different cell that you want to use for the answer to appear. Let’s assume that you have selected cell B2 for it.
- In order to round this number up to 2 digits after the decimal point, you can use the following round function in excel:
- Once you hit enter or click on a different cell after entering this formula, cell A2 will now show your inserted number rounded to 2 digits after the decimal point.
As evident from the roundup excel formula, you can use it to round a number up to as many digits after the decimal point as you wish. You can replace the 2 in the formula with 1 in order to round your entered number up to one digit after the decimal point. If it is replaced with a 0 instead, however, you will find the answer as an integer with no decimal point, to begin with.
In the example mentioned above, your answer would be “125.48” when you use round function in excel with 2 digits after the decimal.
With 1 digit after the decimal, it will reduce to “125.4”, while using 0 in the formula will display the answer as “125” only.
But that’s not all.
There’s a lot more fun that you can get out of the excel round function.
Using round excel formula, it is also possible to round a number to the closest power of 10. Consider the same example given above, if you wish to round the number to the closest 10th, you can use the following formula instead:
Cell B2 will now show the rounded number as “130” as it is the closest 10th. Take a look at the picture given below for better understanding.
If you replace “-1” with “-2” in this formula, Excel will round the number to the closest 100. The cell will now show the answer as “100”. Similarly, you can replace “-1” with “-3” to round the number to the closest 1000.
Remember that you can apply the excel round formula on negative numbers as well. Rounding in excel works in an identical fashion with negative numbers.
How To Roundup In Excel?
Excel roundup function is quite identical to the “Round” function as discussed above.
There is only one distinction between the two formulas. As the name suggests, “Roundup” is always used to round a number “UP”. In other words, “Roundup” always rounds the number further from the zero.
Let’s take a closer look at the steps with an example to better understand how to roundup in excel.
- Launch Microsoft Excel on your device. In order to open a new spreadsheet in which you can enter your data, click on the “Create New Sheet” button.
- Once you are in the spreadsheet, click on a cell of your choice. By double-clicking, you can enter the editing mode and type in the numeric value. In this example, let’s stick to the same number that we have been considering so far.
- After entering the number, click on a different cell to select it for the answer to appear. Now type in the following formula to use excel roundup.
- You can now press enter or simply click on a different cell for cell B2 to display the rounded up figure.
Please note that the second digit after the decimal point was 8 as written in cell A2. In cell B2, however, it has been rounded “UP” to “9” instead.
It is noteworthy that you can decide the number of digits after the decimal point while using the excel roundup formula. By replacing the digit 2 with any other number, you can get an answer with that many digits after the decimal point. If you replace it with a “0”, the number will be rounded up to the closest integer. Since it must be rounded “UP”, you will get an answer of “126” in such a scenario.
Other than that, you can use round up excel much in the same way as you did the “Round” function.
To roundup the number to the closest power of 10, you can insert -1, -2, -3, etc. in the formula with -1 rounding the number up to the closest 10th, -2 rounding it up to the closed 100, and so on and so forth.
An important thing to remember is that while dealing with negative numbers, the roundup function in excel will still round your numeric value away from zero.
So, rounding up the number that we have been considering for this example “125.48293” to the closest integer will answer “126”. Using roundup in excel to the closest 10th will answer “130” and to the closest 100 will answer “200”.
How To RoundDown in Microsoft Excel?
Lastly, the “RoundDown” function in excel is much like the roundup feature that we have already discussed. As the name suggests, however, this function is useful when you want to round a number “down” or towards the zero.
Here are the steps to follow to use “RoundDown” function in excel:
- Launch Microsoft Excel on your device and open a new spreadsheet by clicking on the “Create New Sheet” button.
- In the new spreadsheet, choose a cell of your choice to insert your data. You can double click on the cell in order to type your data.
- Write a numeric value in this cell. Type “125.48293”, the number that we have been considering for this example.
- Now double click on a different cell to edit it. This is the cell that you will be using for the answer to appear. Use the following formula to round down the entered value in excel.
- Now press enter or click on a different cell. Your selected cell for the answer will now display “125.48”, i-e, the original number rounded down up to two digits after the decimal point.
The rest of the process of using “RoundDown” function in excel is exactly the same as in the case of round in excel and the roundup function. You can use it to round a number down up to as many digits after decimal points as you want. You can also round your inserted numeric value up to the closest integer, closest 10th, 100th, etc. with exactly the same modifications to the formula as explained above.
So, now you have been introduced to the excel round, excel roundup, and excel rounddown function in Microsoft Excel.
With this tutorial, you must have learned what these functions are, how to use them in excel, and what purpose can they serve for you in terms of data management and analysis.
You have all the information that you require.
It’s time that you practice these functions extensively to understand them fully. If you still find yourself with a query or confusion that you would like answered, please feel free to leave a comment. Our experts will help you out with it as soon as possible.