ROUNDUP: Rounds a numeric value away from zero at the requested precision. For example, =ROUNDUP(-3.74,0) produces -4, not -3. This is different from simply increasing a signed number.

Official syntax: ROUNDUP(num-to-round, digits) — Apple’s ROUNDUP reference (current English Functions Help 15.4, accessed October 11, 2026). This guide describes the documented behavior, not an observation from an Apple Numbers application session.

Use ROUNDUP when fractional positive quantities must be rounded to complete units, or to conservatively increase a positive estimate. For negative numbers the result moves away from zero, so test both signs before applying it to refunds or financial reporting.

Numbers stores numeric cell values separately from how many decimal places are shown. When a formula actually rounds or truncates a number, downstream arithmetic uses the formula result; changing display formatting alone does not change the underlying numeric value. In particular, distinguish negative inputs from positive values before choosing a rounding rule.

=ROUNDUP(num-to-round, digits)

ROUNDUP requires both arguments, even when digits is zero; do not omit the second argument. With a comma decimal separator, use =ROUNDUP(B2;C2). Apple’s English documentation uses a comma between function arguments and a decimal point for numbers such as 3.74. Numbers’ localized argument separator can change: Apple’s Functions overview says use semicolons between arguments when the decimal separator is a comma. Translate both your decimal notation and argument separator for your locale instead of pasting an English formula unchanged.

Official behavior worth checking: In Apple’s documented examples, ROUNDUP(1.23456,3) returns 1.235, and ROUNDUP(1111.222,-2) returns 1200.

Create an Apple Numbers table named Rounding Lab. Set row 1 as a header row. Enter the inputs below as numeric values, not numeric-looking text. Use these headings: A = Case, B = Input, C = Digits, D = Result. Columns A and C are descriptive/argument fields; you do not type the formula text in the same cell as the input.

Column B is the numeric input, C is the number of digit positions, and D contains =ROUNDUP(B2,C2). Enter both arguments, including an explicit zero for whole-number rounding.

Copy the first formula in D2 down through D9, allowing relative row references to adjust. For the INT case, use =INT(B2) through =INT(B9) and ignore column C. For each other function, use =ROUNDUP(B2,C2) through =ROUNDUP(B9,C9).

Validation disclosure: Each expected value above was independently computed with Python’s decimal.Decimal fixed-point arithmetic and an explicit directional rounding rule. Those are mathematically expected outputs, not native Numbers outputs; automatic type conversion, locale interpretation and imported values still require testing in Numbers. A value shown as 13 could be formatted as 13.00 without changing the underlying number.

=ROUNDUP(-3.74,0) → -4; =ROUNDDOWN(-3.74,0) → -3; =INT(-3.74) → -4. INT and ROUNDUP agree here but do not always agree; for positive 3.74, INT returns 3 while ROUNDUP returns 4.

The four distinct operations matter when results cross zero. INT uses floor (toward negative infinity); ROUNDUP means away from zero, ROUNDDOWN means toward zero, and TRUNC discards digit positions toward zero. The last two give the same numeric outputs for the ordinary examples in this guide, but one must still respect their specific documented argument requirements. For side-by-side Apple context consult the official rounding-functions comparison.

Calculate complete shipping cartons

With 14 items in B12 and 6 items per carton in C12, use =ROUNDUP(B12/C12,0) for the expected 3 cartons. Use this technique only for nonnegative integer quantities and a strictly positive carton capacity; check for division by zero before shipping decisions.

Round positive working time up to quarter hours

For 1.1 hours in B13, =ROUNDUP(B13/0.25,0)*0.25 gives 1.25 hours. This works because the hours are first converted to quarter-hour units; do not confuse rounding to two decimal places with rounding to the nearest 0.25 hour. For payroll, confirm applicable rules before automatically rounding recorded time.

Round a positive budget estimate to hundreds

With 321 in B14, =ROUNDUP(B14,-2) gives 400. The -2 means two places left of the decimal, not negative decimal precision or a subtraction. For a negative estimate, the result would become more negative.

• Rounding a negative number goes the ‘wrong way’: -3.74 becomes -4 when digits is 0 because this function rounds away from zero.
• Missing digits argument: Apple’s syntax requires a second numeric argument, even when you want a whole number: use ROUNDUP(B2,0).
• Need increments such as 0.25 or packs of 6: use a scaling formula with a nonzero divisor; a digits argument alone controls powers of 10, not arbitrary steps.
• Result looks unchanged: the number may already have no nonzero digits beyond the requested position, or the display format may hide digits.
• Unrecognized syntax or wrong result: confirm the formula begins with =, the correct number of arguments was entered, and B2 contains a number rather than text that happens to look numeric. Use the formula editor to confirm the argument separators for your locale.
• The cell reference comes from another table: Apple’s reference style may require a qualified address such as Rounding Lab::B2 (or a sheet-qualified form). Selecting the referenced cell via the formula editor is preferable to manually guessing punctuation.
• Floating-point and extreme-value edge cases: this guide has not exercised the actual Apple Numbers numeric engine. Do not infer exact treatment of values near its precision limits, nonnumeric operands, very large digit counts, or other undocumented coercion rules from the ordinary examples.
• No platform test: native Numbers on Mac, iPad/iPhone, and web/iCloud versions were not tested. The Apple Functions Help 15.4 documentation edition does not establish the first product release in which each function was available.

For debugging, isolate the smallest failing call and compare its input types and argument count to Apple’s value types and the exact function page before adding nested formulas.

A same-table formula refers to B2; a different table may need Rounding Lab::B2; other-sheet references can include the sheet and table using ::, as documented in Apple’s cell-reference guide. Relative references move when copied downward; absolute references require explicit locking in the formula editor.

Cell format controls visible decimal places, thousands separators and decimal symbols, not the logical definition of rounding. For examples using a decimal comma, enter 3,74 as a localized numeric input and use a semicolon to separate multiple function arguments. Re-check converted formulas after CSV imports or workbook transfers. The examples were checked against documentation, not rendered on each locale/platform.

Microsoft Excel documents a function named ROUNDUP in its official function reference. Google Sheets lists corresponding functions in its official functions list. Similar names do not prove identical coercion, text-input recognition, locale delimiters, precision, or error handling. Transfer the test data above to the target application and independently inspect results before using it for business or regulated calculations.

• INT: Apple Functions Help — Returns the greatest integer that is less than or equal to its numeric input. For negative value.
• ROUNDDOWN: Apple Functions Help — Rounds toward zero, retaining only the specified decimal places. With zero digits, `=ROUNDDOWN(-.
• TRUNC: Apple Functions Help — Discards digit positions beyond the requested precision toward zero. =TRUNC(-3.74) gives *-3.
• Apple numeric argument/value types — argument-type distinctions.
• Apple functions overview — formula syntax and localized separator behavior.

These are official external help links, links to official vendor documentation.

• Apple Numbers — function documentation
• Apple’s Functions overview
• official rounding-functions comparison
• Apple’s value types
• Apple’s cell-reference guide
• INT: Apple Functions Help
• ROUNDDOWN: Apple Functions Help

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.