WPS Features
Resources
Free AI Tools
Docs Center

How to Use the ISNA Function in WPS on Windows

Last updated:July 13, 2026

Use the ISNA function in WPS with 3 how-to topics; all 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert ISNA from the Insert Function dialogFree
22. Type the ISNA formula directly in a cellFree
33. Review ISNA syntax and parameter detailsFree

How-to Guide

1. Insert ISNA from the Insert Function dialog

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for ISNA in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter the value or reference that you want to test in the function arguments dialog.
  6. Click OK to insert the formula.

Success Criteria

  • Interface result: The target cell now contains the ISNA function.
  • Next action available: You can continue editing the argument and review the returned result.

Tips While Using

  • Searching with the uppercase function name ISNA can help you find it faster.
  • The argument can be a cell reference, a formula result, or a direct value.

2. Type the ISNA formula directly in a cell

Entry point: Cell / formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =ISNA(...) directly.
  3. Enter the value, cell reference, or formula that you want to test inside the parentheses.
  4. Press Enter to confirm.

Success Criteria

  • Interface result: The cell displays TRUE or FALSE.
  • Next action available: You can fill down or copy the formula to other cells for batch use.

Tips While Using

  • If you want to test the result of another formula, place that formula inside ISNA().
  • When copying the formula, check whether relative or absolute references are needed.

3. Review ISNA syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter ISNA in the search box.
  3. Select the function to review its syntax and parameter details.
  4. Confirm the argument format, then insert or edit the formula as needed.

Success Criteria

  • Interface result: You can review the ISNA function name, argument area, or help details.
  • Next action available: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

  • Reviewing the parameter details first can reduce input mistakes.
  • If you plan to combine ISNA with IF, confirm the return logic before nesting formulas.