Difference between revisions of "Documentation/How Tos/Calc: ISREF function"

Latest revision as of 13:26, 31 January 2024

FUNCTIONS

Tests if the argument is a reference to a cell or range of cells.

ISREF(value)

Returns TRUE if value is a reference to a cell or range of cells and FALSE otherwise.

ISREF(C5)

returns TRUE, because C5 refers to a cell.

ISREF(A1:B3)

returns TRUE, because A1:B3 refers to a range of cells.

ISREF("A5")

returns FALSE, because "A5" is text, not a cell reference.

ISREF(NA())

returns FALSE, because NA() is an error, not a cell reference.

ISREF(A9999999)

returns FALSE, because cell A9999999 does not exist.

ISREF(range1)

where range1 is the named range A1:B3, returns TRUE.

ISREF(range2)

where range2 is not defined, returns the #NAME? error

ISREF(INDIRECT(C1))

where cell C1 contains the text "D1", returns TRUE, because INDIRECT returns a reference.

The ODFF standard is not clear what ISREF should return when presented with an undefined range.

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:ISREF function}}
+{{Documentation/CalcFunc InformationTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_ISODD_ADD_function
+|NextPage=Documentation/How_Tos/Calc:_ISTEXT_function
+}}__NOTOC__
 == ISREF  ==
@@ Line 34: / Line 39: @@
 : where cell C1 contains the text <tt>'''"D1"'''</tt>, returns <tt>'''TRUE'''</tt>, because <tt>'''INDIRECT'''</tt> returns a reference.
-{{Documentation/SeeAlso|
+=== Issues: ===
+* The ODFF standard is not clear what <tt>'''ISREF'''</tt> should return when presented with an undefined range.
+{{SeeAlso|EN|
 * [[Documentation/How_Tos/Calc: TYPE function|TYPE]]
@@ Line 41: / Line 49: @@
 * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
+[[Category: Documentation/Reference/Calc/Information functions]]
-=== Issues: ===
-* The ODFF standard is not clear what <tt>'''ISREF'''</tt> should return when presented with an undefined range.