ISREF

Formulas / ISREF
Test if a cell contains a reference.
=ISREF(value)
  • value - required argument that can be a blank cell, error, logical value, text, number, or reference value.

Examples

  • =ISREF(A1)

    The function evaluates a single cell reference or a range of cell references, and returns TRUE if a reference is found, and FALSE if not. For example, this returns TRUE if A1 contains a reference and FALSE if not.

  • =ISREF(A1:C1)

    The function can also be used to evaluate a range of cell references. For example, this returns TRUE if A1:C1 contains a reference and FALSE if not.

  • =ISREF(Sheet1!A1)

    The function can also be used to evaluate a reference in a different worksheet. For example, this returns TRUE if the reference in A1 is in Sheet1 and FALSE if not.

  • =ISREF("apple")

    The function does not evaluate the contents of a reference. For example, this returns FALSE because ISREF does not evaluate the contents of a reference.


Summary

The ISREF function tests a value and returns a boolean result depending on the outcome. It can be used to determine if a value is a valid reference or not.

  • The ISREF function takes one argument, a reference value, which is used to test if the cell contains a reference, range, or named range. The function returns TRUE if the cell does contain a reference and FALSE if the cell does not contain a reference.
  • The ISREF function does not check for a reference in a formula.

Frequently Asked Questions

What is the ISREF function?
The ISREF function is a logic function in Sourcetable that returns TRUE if the value argument is a reference to an empty cell.
What does the ISREF function do?
The ISREF function returns TRUE if the value argument is a reference to an empty cell and FALSE if the value argument is not a reference to an empty cell. It can be useful for verifying the outcome of a calculation.
Does the ISREF function return TRUE if the value argument references a text cell?
Yes, the ISREF function returns TRUE if the value argument references a text cell.
Does the ISREF function return FALSE if the value argument is not a reference to a text cell?
Yes, the ISREF function returns FALSE if the value argument is not a reference to a text cell.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV