INDIRECT in WPS Spreadsheet converts text references into valid cell or range references; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | All listed tasks are available directly |
About This Feature
Overview
The INDIRECT function is a built-in function in WPS Spreadsheet for turning a text reference into a usable cell or range reference. It is useful for dynamic references, cross-range lookups, and formula structures that need flexible reference targets.
Core capabilities include:
- Finding and inserting the INDIRECT function from the Insert Function dialog box.
- Typing
=INDIRECT(...)directly in a worksheet cell or the formula bar. - Reviewing syntax and parameter details from the function help entry before confirming a formula.
This function fits worksheet building, reference switching, and repeated formula maintenance, helping reduce manual edits to reference addresses.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory connection is required for local formula entry; an internet connection is recommended when opening online help |
| Other | You need to open WPS Spreadsheet and edit worksheet cells |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office and then open Spreadsheet to confirm that entries such as Formula and Insert Function are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Provides worksheet function entry, parameter filling, and function help access for using INDIRECT in dynamic references. | Word supports formulas in table cells through the Formula command, but the feature is designed for document tables rather than a spreadsheet function system. | The official Google Docs page highlights Gemini writing, summarizing, and question-answering features rather than worksheet-style INDIRECT entry. | Notion formulas work with database properties, built-ins, and functions for database calculations instead of traditional cell-address spreadsheet references. | Acrobat forms can use JavaScript for calculations, formatting, and validation in PDF forms rather than worksheet function editing. |
| WPS Advantages | Advantage: WPS keeps formula entry, parameter input, and reference calculation inside a spreadsheet interface, which fits everyday worksheet formula work. | Compared with WPS: the formula workflow is centered on Word table calculations inside documents. | Compared with WPS: the official page focuses on AI assistance in documents, not a worksheet function input flow. | Compared with WPS: the formula model is oriented to database properties and automation instead of cell reference formulas. | Compared with WPS: the workflow is oriented to PDF form scripting and field behavior rather than spreadsheet formula entry. |
| Official Source | — | Use a formula in a Word table | Gemini in Google Docs | Intro to formulas | Using JavaScript in Forms |
Overall Conclusion
If your main task is entering dynamic references and worksheet formulas, WPS follows a spreadsheet-oriented workflow more closely. The other products also provide calculation or automation features, but their primary scenarios are document tables, database formulas, or PDF form processing.
Use Cases
| No. | Scenario | Suitable for | Main issue | How it helps |
|---|---|---|---|---|
| 1 | Switching reference targets dynamically | Finance and operations staff | Reference addresses change often and manual edits take time | Use INDIRECT to convert text addresses into references |
| 2 | Entering formulas with a function wizard | New users | Parameter order is not always familiar | Fill in parameters through the Insert Function dialog box |
| 3 | Checking formula syntax | Worksheet maintainers | Formula errors are hard to locate quickly | Review syntax and parameter details from the function help entry |
| 4 | Reusing formulas across cells | Data organizers | References can shift incorrectly during reuse | Confirm the INDIRECT structure before copying to the target range |
| 5 | Combining with other functions | Advanced users | More flexible reference logic is needed | Use INDIRECT together with text or reference-related formulas |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic spreadsheet functions | Available | Available |
| Basic PDF features | Basic PDF access | More PDF tools and conversion features |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited access | Access to more template resources |
| AI tools | Some features are limited | More AI features and higher usage allowances |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Everyday formula entry and basic worksheet editing | Free | Basic spreadsheet functions such as INDIRECT are available directly for regular office work |
| Work that also needs more PDF, cloud, or AI features | WPS Premium | Suitable when you need a broader set of office tools and online resources |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page