How to Use the OR Function in WPS on Windows

Last updated:July 23, 2026

Use the OR function through 3 how-to topics, all available without membership, and jump to each section from the How-to Index.

How-to Index

No.TopicMembership
11. Create a formula field and use ORFree
22. Check the argument format and enter it correctlyFree
33. Write an OR example formulaFree

How-to Guide

1. Create a formula field and use OR

Entry path: Add Field → Formula

  1. Open the multi-dimensional table that you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes OR in the formula editor.
  5. Click Confirm to save and review the calculated result.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can continue editing the formula or review the returned result.

Tips While Using

  • Common mistake: If you do not create a formula field first, you cannot enter the function formula directly.
  • Environment note: You need edit permission for the current multi-dimensional table.

2. Check the argument format and enter it correctly

Entry path: Formula Editor → Function Library → OR

  1. Open the function library in the formula editor.
  2. Select the OR function to review its syntax.
  3. Enter arguments in the following structure:
OR(
  [argument1],
  [argument2],
  ...
)
  1. Fill in the required conditions based on your actual logic.
  2. Check commas, parentheses, and argument order before saving.

Success Criteria

  • Interface result: The full OR syntax is visible in the formula editor.
  • Next action available: After saving, the field can return TRUE or FALSE normally.

Tips While Using

  • Common mistake: Missing separators between arguments or leaving parentheses unclosed.
  • Environment note: The field type should match the logic used in the formula.

3. Write an OR example formula

Entry path: Formula Editor

  1. Enter an example formula in the formula field.
  2. Replace the sample conditions with actual fields or conditions.
  3. Save the formula and check whether the result updates when data changes.

Example:

=OR(condition1, condition2)

Success Criteria

  • Interface result: The formula field shows a calculated result.
  • Next action available: When you change the conditions, the result updates accordingly.

Tips While Using

  • Common mistake: Leaving the sample conditions unchanged may produce results that do not match your data.
  • Environment note: Formula field results update when the source data changes.