ISREF Function in Excel

Home/Excel Formulas/ISREF Function in Excel

What is the use of ISREF function?

ISREF Function in Excel returns TRUE if the given value is a reference, otherwise returns FALSE

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


What is the syntax of ISREF function?

ISREF Function in Excel - Syntax

ISREF( value)

value : value to be checked

ISREF Function in Excel – Examples

ISREF Function in Excel - Example

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

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference
By |March 24th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.