Checks whether the cell identified by the specified reference contains a formula.
Syntax
 Copy Code
|
|---|
ISFORMULA( Reference r ) → Logical |
Parameters
- r
- Required. The reference to the cell to test.
Remarks
If r references a cell containing a formula, the function returns TRUE; otherwise, FALSE. If r is not a valid cell reference, the function returns the #VALUE! error value.
Example
| Formula
Copy Code
|
|---|
=ISFORMULA(A1) |
See Also
Function Reference
ISTEXT Function
ISNUMBER Function