ExcelFlux

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

RowA
6Raw amount
712.789
8-12.789
9128
Two decimals
=ROUNDUP(A7,2)

Expected result12.79

See the inputs and instructions for all 3 examples

Syntax

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
Microsoft Excel reference