ISREF

Check a cell for valid reference in Excel
Returns TRUE if the value is a reference

Rational

Check a cell for valid reference

Description

The Excel ISREF function checks if a specified cell has a correct reference and returns “TRUE” when a cell has a valid reference, and “FALSE” for reference error or formula is not linked to any cell.

Syntax

=ISREF (value)

Parameters

value – Cell for reference check

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

The ISREF formula returns TRUE only if the value in the cell is linked to a valid reference and FALSE if does not. The function will also return FALSE if the argument is manual.

For example, =ISREF(B6) will return TRUE, and =ISREF(“TEXT”) will return FALSE, “TEXT” is entered manually in the latter case.

The ISREF formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

Keep Reading Similar Functions:

ISFORMULA

The ISFORMULA function check if a specified cell is containing a formula and returns “TRUE” if it contains, I.e., cell C6 =2+2, “=ISFORMULA(C6)” returns TRUE.

Read More »
Check if a cell is blank in Excel

ISBLANK

The ISBLANK function checks if a cell is blank and returns “TRUE” when it is, I.e., “=ISBLANK(“Text”)” return FALSE as the cell contains some value “Text”.

Read More »
Check if cell returns a logical value in Excel

ISLOGICAL

The ISLOGICAL function check if a specified cell has Boolean value and returns “TRUE” when a cell has a Boolean data type, and “FALSE” if it does not.

Read More »