How to Use the INDIRECT Function in WPS on Windows

Last updated:July 20, 2026

Use the INDIRECT function in 1 how-to topic; start from the How-to Index and follow the steps to enter the formula and return a result.

How-to Index

No.TopicMembership Requirement
11. Use the INDIRECT functionFree

How-to Guide

1. Use the INDIRECT function

Entry: Formulas tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell.
  3. Enter INDIRECT( and review the syntax guidance that appears.
  4. Enter the required arguments and press Enter to return the result in the cell.

Success Criteria

  • Interface result: the cell displays the returned result of the INDIRECT formula.
  • What you can do next: you can continue editing arguments, copy the formula, or save the spreadsheet.

Tips While Using

  • Common mistake: missing parentheses, quotation marks, or argument separators can cause an error.
  • Environment note: for cross-sheet references, make sure the worksheet name and address are entered correctly.