Excel ISREF Function

HomeExcel FunctionsExcel ISREF Function (Example + Sample File)

What is EXCEL ISREF FUNCTION

The Excel ISREF Function is listed under Microsoft Excel's Information Functions category. It returns TRUE is the referred value is a valid reference, else FALSE. In simple words, you can use ISREF to check if a text value is a valid reference or not.

How to use it

To learn how to use the ISREF function in Excel, you need to understand its syntax and arguments:

Syntax

ISREF(value)

Arguments

  • value: The value for which you want to check for a valid reference.

Notes

  • If a valid reference address enclosed in double quotation marks ISREF will not able to test that reference and return FALSE even that reference is valid.

Example

To master the ISREF function we need to try it out in an example, so make sure to check out the below one:

In the below example, the fruit is a valid named range but when you have used double quotation marks, ISREF is unable to test that reference.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.