# Documentation/Calc Functions/ISREF

Other languages:
English • ‎Nederlands

ISREF

Information

## Summary:

Determines whether the supplied argument is a reference or reference list.

ISREF(Value)

## Returns:

Returns TRUE if the argument is a reference or reference list and FALSE otherwise.

## Arguments:

Value is the value to be tested to determine whether it is a reference.

• ISREF does not examine the contents of any cells that are referenced.

## Examples:

Formula Description Returns
=ISREF(C5) Here the function returns TRUE because C5 is a valid cell reference. The current content of cell C5 is not checked. TRUE
=ISREF(aRange~Y1:Z6) where aRange is a valid named range. Here the function returns TRUE because the argument is a valid reference list. TRUE
=ISREF(anotherRange) where anotherRange is NOT a valid named range or database range. Here the function returns FALSE because the argument is not a valid reference list. FALSE
=ISREF(INDIRECT("A6")) Here the function returns TRUE, because the INDIRECT function returns a reference. Note that the behaviour of the INDIRECT function is affected by the setting of the Formula syntax option on the Tools ▸ Options ▸ LibreOffice Calc ▸ Formula (LibreOffice ▸ Preferences ▸ LibreOffice Calc ▸ Formula on macOS) dialog. For this example, A6 is not a valid cell reference if the Formula syntax option is set to Excel R1C1. TRUE
=ISREF(ADDRESS(1; 1; 2; "Sheet2")) Here the function returns FALSE, because the ADDRESS function returns a text string, which is not a reference although it may appear to be. FALSE
=ISREF("The spreadsheet for everyone.") Here the function returns FALSE because the argument is a text string rather than a reference. FALSE
=ISREF(42) Here the function returns FALSE because the argument is a number rather than a reference. FALSE

ISREF