How to Use the ROUND Function in WPS on Windows

Last updated:July 23, 2026

Use ROUND through 3 how-to topics, including creating a formula field, setting arguments, and validating example formulas; open the How-to Index and follow the steps for each task.

How-to Index

No.TopicMembership
11. Create a formula field and call ROUNDFree
22. Set ROUND argument formatFree
33. Write and verify a ROUND exampleFree

How-to Guide

1. Create a formula field and call ROUND

Entry: Add Field → Formula

  1. Open the multidimensional table where you want to process data.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes ROUND in the formula editor.
  5. Click Confirm and review the calculated result in the new field.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can keep editing the formula or review results for each record.

Tips While Using

  • Common mistake: If you do not choose the Formula field type first, you cannot enter the function correctly.
  • Environment note: You need edit permission for the current multidimensional table.

2. Set ROUND argument format

Entry: Formula Editor → Function Library → ROUND

  1. Locate ROUND in the formula editor.
  2. Enter the value or field that you want to process.
  3. Enter the number of decimal places to keep.
  4. Check that parentheses, commas, and field references are correct.
  5. Save the formula and confirm that the result matches your expectation.

Success Criteria

  • Interface result: The formula saves without an error message.
  • Next action available: Updating the arguments changes the result accordingly.

Tips While Using

  • Common mistake: Using a text field directly as a number may produce an unexpected result.
  • Environment note: If a field name changes, review the original formula reference as well.

3. Write and verify a ROUND example

Entry: Formula Field → Edit Formula

  1. Enter a sample ROUND formula in the formula field.
  2. Replace sample values with actual business fields or numbers.
  3. Combine ROUND with other functions if needed.
  4. Save the formula and compare the rounded result with the original value.
  5. Update the source data and confirm that the formula result refreshes automatically.

Success Criteria

  • Interface result: The formula field shows the rounded output.
  • Next action available: When source data changes, the result changes as well.

Tips While Using

  • Common mistake: Leaving sample values unchanged can make the result irrelevant to your workflow.
  • Environment note: Test a simple formula first before expanding to nested logic.