Excel allows us to round a decimal number up to a certain number of decimal places, by using the ROUNDUP function. This step by step tutorial will assist all levels of Excel users in rounding a decimal number up.
Figure 1. The result of the ROUNDUP function
Syntax of the ROUNDUP Formula
The generic formula for the ROUNDUP function is:
The parameters of the ROUNDUP function are:
- number – a number which we want to round
- num_digits – a number of decimal places to round.
Setting up Our Data for the ROUNDUP Function
In column B (“Number”), we have the list of numbers and in column C (“Number of decimal places”) we have a number of decimal places for rounding. In column C (“Rounded number”), we want to get a number rounded up.
Figure 2. Data that we will use in the ROUNDUP example
Round a Number Up
In our example, we want to round numbers up from column B to decimals in column C.
The formula in the cell D3 is:
The parameter number is the cell B3, while the num_digits is C3.
To apply the ROUNDUP function, we need to follow these steps:
- Select cell D3 and click on it
- Insert the formula:
- Press enter
- Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.
Figure 3. Using the ROUNDUP function
When rounding the number, the function will always round a number up, regardless of the next decimal. We can see that in row 4, 2.76539 is rounded to 2.766. In the simple round, this number would be rounded to 2.765, because the next decimal is 3.
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.