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

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.