Documentation/Calc Functions/ISREF

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

ISREF

Category:

Information

Summary:

Tests if the argument is a reference.

Syntax:

ISREF(Value)

Returns:

Returns TRUE if the argument is a reference, returns FALSE otherwise. When given a reference this function does not examine the value being referenced.

If an error occurs, the function returns a logical or numerical value.

Arguments:

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

Additional details:

Examples:

=ISREF(C5) returns the result TRUE because C5 is a valid reference.

=ISREF("abcdef") returns always FALSE because a text can never be a reference.

=ISREF(4) returns FALSE.

=ISREF(INDIRECT("A6")) returns TRUE, because INDIRECT is a function that returns a reference.

=ISREF(ADDRESS(1; 1; 2;"Sheet2")) returns FALSE, because ADDRESS is a function that returns a text, although it looks like a reference.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: