Difference between revisions of "Documentation/How Tos/Calc: ISREF function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
(→See also:) |
||
| Line 35: | Line 35: | ||
=== See also: === | === See also: === | ||
| − | '''[[Documentation/How_Tos/Calc: TYPE function|TYPE | + | '''[[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''']], | ||
| + | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] | ||
=== Issues: === | === Issues: === | ||
* The ODFF standard is not clear what <tt>'''ISREF'''</tt> should return when presented with an undefined range. | * The ODFF standard is not clear what <tt>'''ISREF'''</tt> should return when presented with an undefined range. | ||
Revision as of 06:28, 13 September 2008
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.
See also:
Functions listed alphabetically, Functions listed by category
Issues:
- The ODFF standard is not clear what ISREF should return when presented with an undefined range.
