How to round up in Excel
using the function ROUNDUP
Let’s first turn our attention to one of the more specialized rounding functions: ‘ROUNDUP’.
If you have a value that’s supposed to be rounded down, Excel will instead round the number up.
So, ’24’ would normally be rounded to the nearest tens with the expected result of ‘20’.
But, when using the ‘ROUNDUP’ function, the result is ’30’!
There are syntax rules that you must follow when rounding in Excel.
Let’s look at the syntax for ‘ROUNDUP’.
The first argument is simply the number we wish to round.
This can be a literal number value in the function or a cell reference to a value we want to round.
The second argument is ‘num_digits’. This is a number value.
It indicates the number of digits to the left/right of the decimal place we would like to round our ‘number’ argument.
- Positive numbers are places to the right of the decimal.
- Negative numbers are places to the left of the decimal.
First, let’s see the different results we get by applying the ‘ROUNDUP’ function to the same number value – but with different ‘num_digits’ values.
Notice that for the number ‘132.54’, we start with a ‘num_digits’ of ‘2’ which is two places to the right of the decimal point.
But, our original value doesn’t go out to that many decimal places. The result of our formula is simply the original value.
Once we change our ‘num_digits’ argument to 1 in the next row, we now see ‘ROUNDUP’ in action.
Now, the value changes from ‘132.54’ to ‘132.6’.
At zero decimal places, a ‘num_digits’ value of ‘0’, our original value is now rounded up to ‘133’ – the nearest integer.
For example, on row 10, our ‘num_digits’ argument is ‘-2’.
This tells ‘ROUNDUP’ to round our original value of ‘406.5’ to the next highest hundredths or ‘500’.