Excel ROUNDUP() Function
Excel ROUNDUP() Function
The ROUNDUP() function in excel returns a number rounded up to the nearest possible value and away from zero.
Syntax
ROUNDUP(Number, num_digits)
Parameter
Number(required)- This parameter represents the number which you want to round up.
num_digits(required)- This parameter represents the number of decimal places to which you want it to round up.
Category
Math & Trig
Returns
This function returns a number rounded up to the nearest possible value and away from zero.
Example 1
Objective: Round up the value to the nearest integer
| Numbers | Rounded | Formula |
| 451.0000000 | 451.00 | =ROUNDUP(A18,0) |
| 123.4500000 | 124.00 | =ROUNDUP(A19,0) |
| 356.3200000 | 357.00 | =ROUNDUP(A20,0) |
| 323.0000000 | 323.00 | =ROUNDUP(A21,0) |
Example 2
Objective: Round up value to the nearest hundredth value.
| Numbers | Rounded | Formula |
| 451.0000000 | 460.00 | =ROUNDUP(A18,-2) |
| 123.4500000 | 200.00 | =ROUND(A19,-2) |
| 356.3200000 | 400.00 | =ROUND(A20,-2) |
| 323.0000000 | 400.00 | =ROUND(A21,-2) |
Example 3
Objective: Round down value to the nearest ten value.
| Numbers | Rounded | Formula |
| 451.0000000 | 451.00 | =ROUNDUP(A18,1) |
| 123.4500000 | 123.50 | =ROUNDUP(A19,1) |
| 356.3200000 | 356.40 | =ROUNDUP(A20,1) |
| 323.0000000 | 323.00 | =ROUNDUP(A21,1) |