How to Use the ODD Function in WPS on Windows

Last updated:July 23, 2026

Use the ODD function through 3 topics: create a formula field, enter the ODD argument correctly, and review the calculated result; choose a topic from the index and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and enter ODDFree
22. Enter the ODD argument in the correct formatFree
33. Review and verify the ODD resultFree

How-to Guide

1. Create a formula field and enter ODD

Entry path: Add Field → Formula

  1. Open the multi-dimensional table that you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. In the formula editor, type ODD( to start the formula.
  5. Name the field if needed, then save the field settings.

Success Criteria

  • Interface result: a new formula field appears in the table.
  • Next action available: you can continue entering the full formula in the editor.

Tips While Using

  • Common mistake: choosing a text or number field instead of a formula field prevents formula logic from being entered directly.
  • Environment note: you need permission to edit the structure of the current multi-dimensional table.

2. Enter the ODD argument in the correct format

Entry path: Formula editor → Enter formula expression

  1. Type a complete expression such as ODD(2) in the formula field.
  2. Replace the fixed value with a numeric field when needed.
  3. Check that the parentheses are complete.
  4. Confirm that the argument can be used in a numeric calculation.
  5. Click Confirm or save the formula.

Success Criteria

  • Interface result: the formula editor accepts the expression without a visible format error.
  • Next action available: after saving, the result can be viewed in the record.

Tips While Using

  • Common mistake: missing parentheses or non-numeric arguments can affect the result.
  • Environment note: if the referenced field is not numeric, the calculation may not return the expected output.

3. Review and verify the ODD result

Entry path: Formula result column

  1. Save the formula and return to the table view.
  2. Check the current value shown in the formula field.
  3. Change the source value and see whether the result updates.
  4. Compare the output with the odd-number rounding rule.

Success Criteria

  • Interface result: the formula field shows an odd-number result.
  • Next action available: when the record changes, the result refreshes automatically.

Tips While Using

  • Common mistake: treating ODD as an odd/even test instead of a rounding function can lead to the wrong formula design.
  • Environment note: result refresh depends on valid source values and a correct formula expression.