ExcelFlux

ISREF function

TRUE if the value is a reference.

Information · Guided Excel example

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Convert address text to a reference and check how Excel classifies it.

A worked example from the workbook

RowA
6Input
7B7
8B8
9B9
Record 1
=ISREF(INDIRECT(A7))

Illustrative outputTRUE

See the inputs and instructions for all 3 examples

Worked examples

Convert address text to a reference and check how Excel classifies it.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 B7
8 B8
9 B9
Trial Expression Sample output
Record 1 =ISREF(INDIRECT(A7)) TRUE
Record 2 =ISREF(INDIRECT(A8)) TRUE
Record 3 =ISREF(INDIRECT(A9)) TRUE
Microsoft Excel reference