ROUNDUP function
Find the number of 12-unit cases needed for 26 units.
Math and trigonometry
Where can you use it?
Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.
Scenario in the workbook
Round away from zero. For negative numbers, the magnitude increases.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Raw amount |
| 7 | 12.789 |
| 8 | -12.789 |
| 9 | 128 |
Two decimals
=ROUNDUP(A7,2)Expected result12.79
See the inputs and instructions for all 3 examplesSyntax
ROUNDUP(number, num_digits)
Copyable formulas
English Excel · en-US
=ROUNDUP(26/12,0)Turkish Excel · tr-TR
=YUKARIYUVARLA(26/12;0)Example and expected result
Divide 26 units by 12 and round up to zero decimal places. Three cases hold 36 units.
Expected result 3.
Worked examples
Round away from zero. For negative numbers, the magnitude increases.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A |
|---|---|
| 6 | Raw amount |
| 7 | 12.789 |
| 8 | -12.789 |
| 9 | 128 |
| Case | Formula | Expected result |
|---|---|---|
| Two decimals | =ROUNDUP(A7,2) |
12.79 |
| Negative amount | =ROUNDUP(A8,2) |
-12.79 |
| Tens | =ROUNDUP(A9,-1) |
130 |