ISFORMULA
Returns TRUE if there is a reference to a cell that contains a formula.
InformationInformation & Auditing
What it does
Checks if a cell contains a formula (starting with =).
Syntax
ISFORMULA(reference)
Arguments
reference(reference) — Cell to check.
Examples
Check Formula
Check A1.
FORMULA
=ISFORMULA(A1)
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | =SUM(1,2) |