IsRef( )

Classic Experience Functions & Formulas
,
1

ISREF( )

Description

ISREF returns TRUE if value is a reference to a cell or range of cells and FALSE if otherwise. ISREF can be used to check if a cell contains a valid reference.

Syntax

=ISREF(value/formula that returns a value)

Required

  • Value/formula: The value to check

ISREF table image

=ISREF(10)

Returns FALSE

=ISREF(FindRow(Tasks, "Tasks[Completed]=%", "Yes")[Owner])

Returns TRUE

=ISREF(Filter(Tasks))

Returns TRUE

Was this article helpful?
  • Yes
  • No

0 voters

2