Checks whether a reference contains a formula and returns TRUE or FALSE.
Syntaxis
ISFORMULA(reference)Argumenten
referencevereist
The cell or range you want to test.
The ISFORMULA function determines if a cell contains a formula. It returns TRUE if the cell contains a formula, and FALSE if it contains a static value or is empty.
=ISFORMULA(A1)→TRUEReturns TRUE if cell A1 contains a formula like =SUM(B1:B5).
=ISFORMULA(100)→FALSEReturns FALSE because 100 is a static number, not a formula.
Select the target cell
Click on the cell where you want the result to appear.
Enter the formula
Type =ISFORMULA( followed by the cell reference you want to check and a closing parenthesis.
Yes, you can reference cells in other sheets using the syntax =ISFORMULA(Sheet2!A1).