How to Use the ROUNDUP Function in WPS on Windows

Last updated:July 23, 2026

Use ROUNDUP through 3 how-to topics, all available without membership; start from the How-to Index and follow the entry path and steps for each task.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call ROUNDUPFree
22. Set the ROUNDUP parameter formatFree
33. Use a ROUNDUP example in a tableFree

How-to Guide

1. Create a formula field and call ROUNDUP

Entry path: Add Field → Formula

  1. Open the table you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes ROUNDUP in the formula editor.
  5. Click Confirm to save and check whether the calculated result appears.

Success Criteria

  • Interface result: A new formula field appears in the table and shows a calculated result.
  • What you can do next: You can continue editing the formula or adjust the field order.

Tips While Using

  • Common mistake: If you choose a plain text field instead of a formula field, the formula will not calculate.
  • Environment note: You need edit permission for the current table.

2. Set the ROUNDUP parameter format

Entry path: Formula Editor → Function Library → ROUNDUP

  1. Search for and select ROUNDUP in the formula editor.
  2. Enter the target value and the rounding place in the function format.
  3. Check that separators between parameters are correct.
  4. Confirm the formula and verify that the result rounds upward as expected.

Success Criteria

  • Interface result: The formula editor recognizes ROUNDUP correctly.
  • What you can do next: When you change parameters, the result updates accordingly.

Tips While Using

  • Common mistake: An incomplete parameter format can cause a formula error.
  • Environment note: The input should match the data type used in the current field.

3. Use a ROUNDUP example in a table

Entry path: Formula Field → Enter an example formula

  1. Select an existing numeric field as the basis for calculation.
  2. Enter a ROUNDUP formula in the formula field.
  3. Set the decimal or integer place according to your business need.
  4. Save the formula and check whether each record refreshes automatically.

Success Criteria

  • Interface result: Each record shows a new rounded result.
  • What you can do next: You can continue combining ROUNDUP with other functions.

Tips While Using

  • Common mistake: Referencing the wrong field can produce unexpected results.
  • Environment note: If imported data is empty, results may not appear immediately.