WPS Features
Resources
Free AI Tools
Docs Center

How to Use the TRUE Function in WPS on Windows

Last updated:July 14, 2026

Use the TRUE function in 3 how-to topics, all available directly in WPS Spreadsheet on Windows, with 3 free items and 0 membership-related items.

How-to Index

No.TopicMembership Requirement
11. Insert TRUE from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review the syntax and function descriptionFree

How-to Guide

1. Insert TRUE 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 open Insert Function from the Formulas tab.
  3. Search for TRUE in the dialog box.
  4. Select the function and click OK.
  5. Review the description that shows the function returns the logical value TRUE.
  6. Click OK to finish inserting the function.

Success Criteria

  • Interface result: the target cell contains the TRUE function.
  • Next action available: after you press Enter, you can see the logical result and continue editing formulas.

Tips While Using

  • The TRUE function does not need any arguments.
  • If the current cell has unusual formatting, clear the content first and then insert the function again.

2. Type the formula directly in a cell

Entry point: Cell or formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =TRUE() directly.
  3. Press Enter to confirm.
  4. Check whether the cell returns the logical value TRUE.

Success Criteria

  • Interface result: the cell accepts the formula and returns TRUE.
  • Next action available: you can copy the formula to other cells or combine it with other logical functions.

Tips While Using

  • Start the formula with an equals sign.
  • If the formula does not calculate, check whether the cell is formatted as text.

3. Review the syntax and function description

Entry point: Formulas tab → Insert Function

  1. Open Insert Function from the Formulas tab.
  2. Search for TRUE.
  3. Select the function to review its syntax and description.
  4. If a help entry is available in the interface, open it for more details.

Success Criteria

  • Interface result: you can see the TRUE function name and its description.
  • Next action available: you can insert the function or revise an existing formula based on the description.

Tips While Using

  • TRUE is commonly used as a fixed logical value and is easier to understand when learned together with IF, AND, and OR.
  • If you cannot find the function, confirm that you are working in WPS Spreadsheet.