What is ISREF function in Excel?
The ISREF function is one of the Information functions of Excel.
It Checks whether a value is a reference, and returns TRUE or FALSE.
We can find this function in Information of insert function Tab.
How to use ISREF function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select ISREF function
6. Then select ok.
7. In the function arguments Tab you will see ISREF function.
8. Value section is the value you want to be tested. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.
9. You will see the results in the formula result section.
Examples of ISREF function in Excel
ISREF related functions
- Use ISLOGICAL function to check whether a value is a logical value, and returns TRUE or FALSE.
- Use ISODD function to return TRUE if the number is odd.
- Use ISNONTEXT function to check whether a value is not text, and returns TRUE or FALSE.
- Use ISTEXT function to check whether a value is text, and returns TRUE or FALSE.
