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.