What is ISFORMULA function in Excel?
The ISFORMULA function is one of the Information functions of Excel.
It Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE.
We can find this function in Information of insert function Tab.
How to use ISFORMULA 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 ISFORMULA function
6. Then select ok.
7. In the function arguments Tab you will see ISFORMULA function.
8. Reference is a reference to the cell you want to test. Reference can be a cell reference,a formula, or a name that refers to a cell.
9. You will see the results in the formula result section.
Examples of ISFORMULA function in Excel
ISFORMULA related functions
- Use ISLOGICAL function to check whether a value is a logical value, and returns TRUE or FALSE.
- Use ISNA function to check whether a value is=N/A and returns TRUE or FALSE.
- Use ISTEXT function to check whether a value is text, and returns TRUE or FALSE.
- Use ISNUMBER function to check whether a value is a number, and return TRUE or FALSE.
