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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
 
(11 intermediate revisions by 5 users not shown)
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  ==
 
== ISREF  ==
 
Tests if the argument is a reference to a cell or range of cells.
 
Tests if the argument is a reference to a cell or range of cells.
−
 
  
 
=== Syntax: ===
 
=== Syntax: ===
Line 9: Line 13:
  
 
: Returns <tt>'''TRUE'''</tt> if <tt>'''value'''</tt> is a reference to a cell or range of cells and <tt>'''FALSE'''</tt> otherwise.
 
: Returns <tt>'''TRUE'''</tt> if <tt>'''value'''</tt> is a reference to a cell or range of cells and <tt>'''FALSE'''</tt> otherwise.
−
 
  
 
=== Example: ===
 
=== Example: ===
Line 36: Line 39:
 
: where cell C1 contains the text <tt>'''"D1"'''</tt>, returns <tt>'''TRUE'''</tt>, because <tt>'''INDIRECT'''</tt> returns a reference.
 
: where cell C1 contains the text <tt>'''"D1"'''</tt>, returns <tt>'''TRUE'''</tt>, because <tt>'''INDIRECT'''</tt> returns a reference.
  
 +
=== Issues: ===
 +
* The ODFF standard is not clear what <tt>'''ISREF'''</tt> should return when presented with an undefined range.
  
−
=== See also: ===
+
{{SeeAlso|EN|
−
'''[[Documentation/How_Tos/Calc: TYPE function|TYPE function]]'''
+
* [[Documentation/How_Tos/Calc: TYPE function|TYPE]]
  
−
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]'''
+
* [[Documentation/How_Tos/Calc: Information functions|Information functions]]
  
−
 
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
−
=== Issues: ===
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
−
* <tt>'''ISREF(INDIRECT(C1))'''</tt> where cell C1 contains the text <tt>'''"apple"'''</tt>, returns <tt>'''TRUE'''</tt>, even though in this case <tt>'''INDIRECT(C1)'''</tt> returns an error, not a reference.
+
[[Category: Documentation/Reference/Calc/Information functions]]
−
* The ODFF standard is not clear what <tt>'''ISREF'''</tt> should return when presented with an undefined range.
+

Latest revision as of 13:26, 31 January 2024

ISREF

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

Syntax:

ISREF(value)

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

Example:

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.

Issues:

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


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_ISREF_function&oldid=259817"
Views
Personal tools
Navigation
Tools
In other languages