Documentation/Calc Functions/ISREF
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ISREF
Category:
Information
Summary:
Determines whether the supplied argument is a reference or reference list.
Syntax:
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.
Additional details:
- 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 | ▸ ▸ ▸ ( ▸ ▸ ▸ 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 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
ISREF