← Back to level 1
Level 1Next
ROUNDUP
A easy rounding formula that always moves a value upward to the precision you choose.
Syntax
=ROUNDUP(...)Step-by-step explanation
- 1Select the numeric value or range that needs to be adjusted.
- 2Choose the rounding or comparison function that matches the outcome you want.
- 3Press Enter and compare the returned value with the original number.
Common mistakes
Using it when normal rounding is enough
Confusing positive and negative behavior
Setting the wrong number of digits
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=ROUNDUP(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =ROUNDUP(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use ROUNDUP when you want to avoid underestimating quantities, time, or billing units.
Match against the syntax block above.