How to Use the NOT Function in WPS on Windows

Last updated:July 23, 2026

Use the NOT function through 3 how-to topics, including creating a formula field, checking the syntax format, and testing a basic example; all 3 topics are available without membership.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use NOTFree
22. Check the syntax formatFree
33. Write and verify an exampleFree

How-to Guide

1. Create a formula field and use NOT

Entry: 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. Enter an expression that includes NOT in the formula editor.
  5. Click Confirm to save the field.

Success Criteria

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

Tips While Using

  • Common mistake: Entering plain text directly as a logical argument may not return the expected result.
  • Environment note: You need edit permission for the current multi-dimensional table.

2. Check the syntax format

Entry: Formula Editor → Function Library → NOT

  1. Open the formula editor in an existing formula field.
  2. Open the function library and find NOT.
  3. Review the function format.
  4. Put your logical expression inside the parentheses.

Common format:

NOT(logical_expression)

Success Criteria

  • Interface result: You can see the NOT function name and its argument position.
  • Next action available: You can continue entering a complete formula in the correct format.

Tips While Using

  • Common mistake: Putting multiple unrelated arguments into NOT can make the expression unclear.

3. Write and verify an example

Entry: Formula Editor

  1. Enter a logical expression in a formula field.
  2. Wrap that expression with NOT to reverse the result.
  3. Save the formula and review the returned value in the record.
  4. Change the source data and confirm that the result refreshes.

Example:

NOT({Completed})

Success Criteria

  • Interface result: The formula field returns TRUE or FALSE.
  • Next action available: After you change the referenced field, the result updates automatically.

Tips While Using

  • Common mistake: If the field type does not match the logical expression, the result may be harder to interpret.