The Excel ISFORMULA function returns TRUE when a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.
Syntax:= ISFORMULA (reference)
The ISFORMULA function syntax has the following arguments:
- Reference Required. 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.
Example: Let’s look at some Excel ISFORMULA function examples and explore how to use the ISFORMULA function as a worksheet function in Microsoft Excel:
Syntax: =ISFORMULA(A2)
Result:
Based on the Excel spreadsheet above, the following ISFORMULA examples would return:
Syntax: =ISFORMULA(A3)
Result: TRUE
Syntax: =ISFORMULA(A4)
Result: TRUE
Syntax: =ISFORMULA(A5)
Result: TRUE
Syntax: =ISFORMULA(A6)
Result: FALSE
Syntax: =ISFORMULA(A7)
Result: FALSE
Syntax: =ISFORMULA(A8)
Result: TRUE
Syntax: =ISFORMULA(A9)
Result: TRUE
Syntax: =ISFORMULA(A10)
Result: TRUE
Syntax: =ISFORMULA(A11)
Result: FALSE
Note:
- Empty cell can have a formula in the cell. The formula returns an empty string in the cell
- When range of cells given in as argument, the function only checks the first cell of the array as returns TRUE or FALSE based only on the first cell.
- The function returns the error if the reference to the function is invalid.
