ROUNDUP moves a nonzero number away from zero at the selected decimal-place precision, rather than taking the nearest representable rounded value. With n=2 it preserves two decimals by rounding away from zero; with n=0 it moves to a whole number; with n=-2 it moves away from zero to the next multiple of 100 if needed. Omitting n rounds away from zero to an integer according to the official reference.

Choose the rounding policy deliberately: ROUND is nearest, ROUNDUP moves away from zero and ROUNDDOWN moves toward zero. They differ around fractional values and some negative numbers; simply displaying fewer decimal places is not equivalent to changing stored values. The SoftMaker 2026 formatting guide distinguishes display formatting from calculation results.

=ROUNDUP(Number, n)

This is the exact English argument order in the 2026 manual. The help page shows two arguments but explicitly allows omitting n:

=ROUNDUP(Number)

Default when omitted: n = 0 in effect (round to an integer), according to the official 2021/2024/2026 descriptions. Noninteger n, overlarge magnitudes and every possible text-coercion rule were not tested, so do not infer support from Excel.

Source: 2026 ROUNDUP function reference. The comma and decimal point in the examples follow the English-language manual; for other locales, confirm the installed input syntax and decimal separator.

Enter the following complete sample data, including the row-1 headings. B and C are ordinary numeric cells, not formatted strings.

1. Open an empty worksheet in your copy of PlanMaker; enter headers in A1:D1 and the values in A2:D7 exactly as displayed. Enter the entries in column B as numeric values, not strings beginning with an apostrophe.
2. Enter the example formula in a free cell such as F2, outside the input range, and press Enter.
3. Compare the value displayed by your installation against the expected result below. The expected result is calculated independently from the printed data and checked against the official described behaviour; it is not a screenshot or a native PlanMaker test.
4. Copy the appropriate follow-up formula to another empty cell (such as F3) to test the negative-value or negative-decimal-place case.

First formula and expected result

=ROUNDUP(B2,C2)

Expected: 12.35. B2 contains 12.344 and C2 contains 2. To move 12.344 away from zero while retaining two decimal places, the expected result is 12.35.

Second formula and expected result

=ROUNDUP(B4,C4)

Expected: -8. The manual confirms this counterintuitive negative-value case: rounding -7.8 away from zero at zero decimal places produces -8 (not -7).

Further self-checks

Every output in this table is an expected value, not a captured application result. The official function page supplies the relevant rounding definitions and selected example outcomes; the other values were calculated independently using decimal arithmetic.

Advanced scenario: calculate required shipping cartons

Place 25 in G2 (items to pack) and 12 in H2 (maximum items per carton). In an empty result cell enter:

=ROUNDUP(G2/H2,0)

Expected: 3 cartons. 25 ÷ 12 = 2.083333…; a partial carton is still one required carton, so rounding away from zero to a whole number gives 3. As a guard against bad input, ensure H2 is a positive, nonzero carton capacity, because G2/H2 otherwise causes division problems. If there are zero items, the same arithmetic returns 0 cartons.

For a negative input such as -7.3, =ROUNDUP(-7.3,0) has documented expected result -8; rounding up here is not synonymous with CEILING or ordinary mathematical ceil.

The most serious confusion is thinking ROUNDUP always increases the signed value: for a negative quantity, away from zero means a more negative number. The PlanMaker manual explicitly describes compatibility with Excel on this negative case.

Never confuse a rounding direction with a rounding display format. If you need an exact monetary policy, fractional storage rules and the location of the rounding step must be reviewed against your requirements. The function is useful for clean decimal-place operations, not evidence of accounting-law compliance.

• Formula shown as text: ensure the formula begins with = and the destination cell is not in a text-only entry mode. PlanMaker requires the equals sign for calculations.
• Unexpected displayed decimals: changing the number format may round only the display. A rounding formula changes the numeric result. Do not mistake the display setting for the operation being performed.
• Unexpected negative result: understand toward zero versus away from zero before using these functions for negative quantities. Neither rule is identical to mathematical floor/ceiling for both signs.
• Formula rejected or #NULL!: check the exact function name, commas/parentheses, arguments and unusual quotation marks. SoftMaker identifies #NULL! as one of the results of unknown functions or invalid argument counts.
• #VALUE!: check nonnumeric source values or incompatible argument types; PlanMaker documents this as an invalid-value/type error in its general error list. The exact error for a particular malformed input was not tested here.
• Broken referenced range / #REF!: verify that original cells were not deleted or moved; this error is documented for invalid references.
• Precision/rounding expectations: binary numeric representation and PlanMaker document-level rounding settings can influence calculations. This batch does not establish all edge cases for enormous values, arbitrary fractional n, or ties after complex floating-point operations. Test boundary data natively before relying on it in production.

Official troubleshooting references: PlanMaker 2026 error values, entering formulas, number formatting, and Calculate document settings.

The official 2021, 2024, and 2026 English-language PlanMaker reference pages each document this named function and the same main Number, n argument order. The manuals describe omission of n and negative n values. This confirms documented availability in those releases, not the first release ever to implement the function. The 2026 manual describes the wider Windows/macOS/Linux/Android/iOS product family, but this guide does not establish execution in every edition, mobile app, licence or platform. Native PlanMaker 2021/2024/2026 runtime tests were not performed.

These references use English decimal-point examples and comma-separated function arguments. PlanMaker’s numeric decimal separator can follow computer regional settings or a custom setting. If copied formulas fail in a different locale, first check the input and function editor rather than assuming that every separator convention is interchangeable. Official 2026 settings reference.

Official release-specific references: PlanMaker 2021 ROUNDUP, PlanMaker 2024 ROUNDUP, and PlanMaker 2026 ROUNDUP.

The 2021/2024/2026 SoftMaker manuals say the function follows Excel-compatible away-from-zero treatment for negative numbers. Excel calls this ROUNDUP(number,num_digits). Google Sheets and LibreOffice Calc also provide ROUNDUP-like functionality, but do not assume their locales or floating-point edge behaviour are identical. For always rounding toward positive infinity rather than away from zero, evaluate CEILING separately; they are not synonyms for negative inputs.

• SoftMaker PlanMaker — function documentation
• SoftMaker 2026 formatting guide
• PlanMaker 2026 error values
• entering formulas
• Calculate document settings
• Official 2026 settings reference
• PlanMaker 2021 ROUNDUP

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

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