How to Use the TRUE Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide includes 3 topics for using TRUE in WPS on Windows, and all 3 topics are available without membership.

How-to Index

No.TopicMembership
11. Create a formula field and enter TRUEFree
22. Check the TRUE syntax and formatFree
33. Combine TRUE in a formulaFree

How-to Guide

1. Create a formula field and enter TRUE

Entry point: Add Field → Formula

  1. Open the target multidimensional table.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter TRUE() in the formula editor.
  5. Click Confirm or save the current settings.

Success Criteria

  • Interface result: The formula field is created and shows a logical result.
  • Next action: You can continue editing the formula or use the result in filtering and logic settings.

Tips While Using

  • Common mistake: If TRUE is entered as quoted text, the formula meaning may change.
  • Environment note: You need permission to edit fields in the current multidimensional table.

2. Check the TRUE syntax and format

Entry point: Formula Editor → Function Library

  1. Open a formula field in the multidimensional table.
  2. Open the formula editor.
  3. Open the function library or function selection area.
  4. Find the TRUE function.
  5. Enter TRUE() in the format shown by the editor.

Success Criteria

  • Interface result: You can see the TRUE function name or its available format in the editor.
  • Next action: You can continue adding other logic functions to build a combined formula.

Tips While Using

  • Common mistake: Writing a no-argument function as if it needs parameters.
  • Environment note: The location of the function library may vary slightly by interface layout.

3. Combine TRUE in a formula

Entry point: Formula Field → Formula Editor

  1. Open an existing formula field or create a new one.
  2. Enter the condition logic you need in the expression.
  3. Use TRUE() as part of the logical return value or condition result.
  4. Check whether the formula syntax is complete.
  5. Save the formula and review whether the result matches your expectation.

Success Criteria

  • Interface result: After saving, the formula returns a logical result or contributes to a more complex calculation result.
  • Next action: You can reuse the formula logic in other records or fields.

Tips While Using

  • Common mistake: Missing parentheses, commas, or nested structure can cause formula errors.
  • Environment note: For complex formulas, test with a small number of records before wider use.