What is the use of ISREF function?
ISREF Function in Excel returns TRUE if the given value is a reference, otherwise returns FALSE
What is the syntax of ISREF function?
ISREF( value)
value : value to be checked
ISREF Function in Excel – Examples
Example 1: Returns TRUE as the given value (A14) is a reference
Example 2: Returns FALSE as the given value is not a reference , =A14+A15 returns a value
Example 3: Returns FALSE as the given value is not a reference, “A16” is a string type value
Example 4: Returns TRUE as the given value (A14) is a reference, Indirect(“A17”) returns a refernce for A17
Reference:
Please refer the below article for more Information Excel functions.
Information Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home