ISREF in WPS Spreadsheet: Distinguish Cell References from Their Contents
Test actual references in WPS Spreadsheet, separate address text from numeric content and audit a small INDIRECT lookup without assuming an error-handling contract.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ISREF checks whether its argument is a reference. The WPS lesson explicitly shows =ISREF(B3) returning TRUE and =ISREF(15) returning FALSE. A cell’s address and its stored value answer different questions.
Availability and version history
- Introduced: documented by 2019-05-14 in WPS material; the first release is not established.
- Availability: the May 2019 shared IS-function reference names ISREF in Windows Personal; the June dedicated lesson has a blank edition field.
- Scope: exact supported builds and other WPS clients remain unverified.
- Checked: October 14, 2026. Documentation and independent examples; no native WPS execution.
Syntax and the question being tested
=ISREF(value)
Supply the reference or value to examine. A successful reference test does not establish that the referenced cell contains a number, contains useful data or satisfies a business rule.
WPS’s shared IS-function documentation lists ISREF among the type tests and explains that these tests do not generally convert their arguments into other types. The dedicated lesson identifies references specifically; its literal number and cell-reference examples are the starting controls here.
Example 1: the same content, different argument forms
Enter 15 in A2 and the text B2 in A3. Enter 42 in B2. Put each test in a separate empty cell.
| Formula | Independently expected result | Question answered |
|---|---|---|
=ISREF(A2) |
TRUE | Is A2 a cell reference? |
=ISREF(15) |
FALSE | Is this literal number a reference? |
=ISREF("15") |
FALSE | Is this literal text a reference? |
=ISREF(A3) |
TRUE | Is A3 a cell reference? |
=ISREF("B2") |
FALSE | Is the quoted address itself a reference? |
=ISNUMBER(A2) |
TRUE | Does A2 contain a number? |
=ISNUMBER(A3) |
FALSE | Does A3 contain a number? |
The fourth result does not validate the text B2 stored in A3. ISREF received the real reference A3. The fifth formula receives text, even though those characters resemble a valid address.
ISNUMBER examines the value’s numeric type. Use the test matching the actual question rather than replacing one with the other.
Example 2: deliberately turn address text into a reference
With the same cells, compare:
=INDIRECT(A3)
=ISREF(INDIRECT(A3))
The independently expected results are 42 and TRUE. WPS’s INDIRECT reference explicitly describes returning a reference identified by text. In the first formula, the worksheet displays that reference’s content; the second tests the reference it returns.
=ISREF("B2") remains FALSE. Merely writing quotation marks around an address does not perform INDIRECT’s operation. These examples use the documented default A1 address style and a same-sheet, existing cell.
Advanced example: audit an address-driven list
Keep B2 as 42, put 17 in B3 and -5 in B4. Enter only the address-text column below in D2:D4. Fill these formulas down:
- E2:
=ISREF(D2) - F2:
=ISREF(INDIRECT(D2)) - G2:
=INDIRECT(D2)
| D, stored address text | E, reference to input cell | F, constructed reference | G, retrieved content |
|---|---|---|---|
| B2 | TRUE | TRUE | 42 |
| B3 | TRUE | TRUE | 17 |
| B4 | TRUE | TRUE | -5 |
The retrieved numeric total is 54 with =SUM(G2:G4). This gives an independent content check in addition to the reference checks. The E column is intentionally uninformative about whether the stored text is a usable address: it checks D2, D3 and D4 themselves.
Change only B3 from 17 to 20. The three reference-test results remain TRUE under the reference model, while G3 becomes 20 and the total becomes 57. A reference can stay valid as its content changes.
Advanced example: combine reference and content controls carefully
For the numeric destinations in the preceding table, add =ISNUMBER(G2) in H2 and fill down. All three values have expected result TRUE. The reference check and the numeric-content check now have separate, inspectable columns.
If B3 is replaced by the text Pending, the constructed reference remains a reference, but the corresponding retrieved content is text and its ISNUMBER test becomes FALSE. This is why a TRUE ISREF result alone cannot validate a calculation input.
The examples do not depend on undocumented reference preservation by INDEX, CHOOSE or an arithmetic expression. Those functions have their own contracts; a value that happens to equal a cell’s content need not carry that cell’s reference identity.
Invalid address and error limits
The WPS INDIRECT page explicitly assigns #REF! to invalid reference text. That establishes the error for INDIRECT itself. It does not establish, from the sources used here, the exact result of wrapping every possible error-producing expression in ISREF.
Do not assume =ISREF(INDIRECT(D5)) is a universal no-error address validator. Error inputs, external workbooks, named-reference edge cases and array-returning expressions require separate verification. The complete worked list uses valid same-sheet addresses so those unresolved cases cannot silently affect its output.
References and verification
- WPS Academy: ISREF, 2019-06-11 (Chinese).
- WPS shared IS-function reference, May 14, 2019 (Chinese).
- WPS INDIRECT reference (Chinese).
- Editorial testing standards.
Complete function-specific sources reviewed. Worked results are independently derived expectations; no native WPS execution was performed. Formulas use English names and comma separators. Check the installed locale before entering them.