Article updated on February 06, 2018

The ISREF function returns TRUE if value refers to a reference.

Formula in cell C3:

=ISREF(B3)

Excel Function Syntax

ISREF (value)

Arguments

value Required. The value you want to check for a reference.