ISNA in WPS on Windows FAQ

Common questions about ISNA usually focus on formula input, result checking, and nested usage; this FAQ includes 3 frequent questions and a short glossary.

FAQ

ISNA returns FALSE, but I think the result is still wrong. What should I check?

1. First, confirm whether the tested value is really #N/A.
2. If the result is another error type, such as #VALUE! or #REF!, ISNA will not return TRUE.
3. Check the referenced cells, lookup formula, and parameters again.
4. If you need to test more error types, use a more suitable error-checking method.

How can I hide #N/A in a lookup formula?

1. Let the lookup formula return its result in a cell, or write it directly inside a nested formula.
2. Wrap it with IF(ISNA(lookup_formula),"Not found",lookup_formula).
3. Press Enter and review whether the displayed result matches your expectation.
4. Then adjust the prompt text based on your needs.

Which functions can I use together with ISNA?

1. You can combine it with IF for conditional output.
2. You can also use it with lookup, reference, or other logical functions to test for #N/A first.
3. In nested formulas, check the parenthesis structure and reference positions carefully.
4. After that, copy or fill the formula into more cells as needed.

Glossary