FILTER in WPS on Windows FAQ

When using FILTER, the most common issues fall into 3 areas: formula errors, nested usage, and result updates; this FAQ includes 3 common questions and a short glossary.

FAQ

How do I check a FILTER formula when it returns an error?

1. Check whether the parameter order is correct.
2. Confirm that the target range and condition field correspond correctly.
3. Review whether the referenced data type matches the formula requirement.
4. Adjust the parameters based on the error message and save the formula again.

Can FILTER be used together with other functions?

1. Start with a basic FILTER formula.
2. Use the FILTER result as an input for another function.
3. After nesting the formula, check whether the returned result matches your expectation.
4. If the result is still incorrect, separate the formula into smaller parts and test them one by one.

Why does the result change after I edit the source data?

1. FILTER depends on the current referenced range and conditions.
2. When the source data changes, the formula field recalculates the result.
3. If the result does not change, check whether the latest formula was saved and whether the correct fields were referenced.

Glossary