Simple way to test whether a cell has a formula. Returns TRUE if the referenced cell contains a formula, and FALSE if not.
Sample Usage
ISFORMULA(B10)
Syntax
ISFORMULA(reference)
- reference - The cell or range for which you want to check whether it contains a formula or not. This can be a direct cell reference, a formula the returns a cell reference, or a name that refers to a cell. If a range is passed to this function, it will only check whether the first cell in the range has a formula.
Examples
ISFORMULA(B10) evaluates to TRUE if B10 contains =A1+B2.
ISFORMULA(B10) evaluates to FALSE if B10 contains 22 because this is a number, not a formula.
Notes
- This function is often used with the IF function.