The following article introduces you to the ISREF function - one of the functions in the information function group is very popular in Excel.
Description: The function returns True if the value is a valid reference value. Application function to check if the value is a reference value or not.
Syntax: ISREF (value)
Inside:
- value: The value you want to check is a reference or not, is a required parameter.
Attention:
- The function returns True if the value is a reference and vice versa the function returns False.
For example:
Is determining the value in value a reference?
- In the cell to calculate enter the formula : = ISREF (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Here if value is blank -> the function returns True.
- Where is not a reference -> enter the formula: = ISREF ("Excel.net")
- Press Enter -> function returns False value :
Above are instructions and some specific examples when using the ISREF function in Excel.
Good luck!