NOT in WPS on Windows FAQ

When using the NOT function, the most common questions involve formula errors, syntax help, and unexpected results; this FAQ includes 3 common answers.

FAQ

What should I do if the NOT function shows an error after I enter it?

1. Check whether the formula starts with =.
2. Check whether the parentheses are complete and the parameter format is correct.
3. Confirm that the input is a logical value, a logical expression, or a valid cell reference.
4. Press Enter again and review the formula hint if needed.

How can I view the syntax for the NOT function?

1. Select any cell in WPS Spreadsheet.
2. Type =NOT(.
3. Review the formula hint shown in the input area for parameter guidance and examples.
4. Complete the parameter and confirm the formula.

Why is the result of the NOT function not what-i-expected?

1. Check whether the referenced cell contains the value you intended to evaluate.
2. Review nested logic or referenced ranges for mistakes.
3. If worksheet data has changed, confirm that the related cells have updated.
4. Edit the formula again and test the logical expression step by step.

Glossary