WPS Features
Resources
Free AI Tools
Docs Center

How to Use the OR Function in WPS on Windows

Last updated:July 13, 2026

Use the OR function in WPS Sheets with 3 how-to topics on Windows; 3 are available without membership and 0 are membership-related.

How-to Index

#TopicMembership
11. Insert the OR function from the Insert Function dialogFree
22. Type an OR formula directly in a cellFree
33. View OR function syntax and parameter guidanceFree

How-to Guide

1. Insert the OR function from the Insert Function dialog

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for OR in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog.
  6. Click OK to finish entering the function.

Success Criteria

  • UI state: The target cell shows the OR formula result.
  • Next actions: You can continue editing parameters, copy the formula, or fill it down.

Tips While Using

  • Common mistakes: An incomplete function name or unmatched parentheses can prevent the formula from calculating correctly.
  • Environment limits: An internet connection may be needed if you open an online help page.

2. Type an OR formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =OR(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review function guidance, type =OR( and press F1 to check the syntax prompt.

Success Criteria

  • UI state: The cell returns TRUE, FALSE, or the corresponding calculation result.
  • Next actions: You can drag the fill handle to apply the formula to other cells.

Tips While Using

  • Common mistakes: Incorrect punctuation or separators can cause a formula error.
  • Environment limits: Whether the shortcut works can depend on the active window focus.

3. View OR function syntax and parameter guidance

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter OR in the search box.
  3. Select the function to view the syntax OR(...).
  4. Click the help link for the function to open more details.

Success Criteria

  • UI state: You can see the function name, syntax structure, and parameter input area.
  • Next actions: You can continue inserting the function or return to worksheet editing.

Tips While Using

  • Common mistakes: If the function is not selected first, the parameter guidance area may not display complete information.
  • Environment limits: Opening the help link usually requires an internet connection.