OpenOffice3.org Calc 3. Information Functions

ISREF(value) Function

Returns a logical value. If the argument “value” contains the refernce to a cell or a reference to a range of cells, the function returns TRUE. If the argument “value” does not contains a valid reference, the function returns FALSE. The argument “value” constains the data to evaluate. For example:

=ESREF(A8) Returns TRUE. Indicates that the argument is the reference to a cell, in this case, the cell A8.
=ESREF(33) Returns FALSE. In this case, the argument is not a reference to a cell.
=ESREF(dddddd33) Returns FALSE. The argument is not a valid reference.
=ESREF(A1:B5) Returns TRUE. The argument is a valid reference.

 

Back to the list of information functions