ISFORMULA
TheISFORMULA
formula checks whether a given cell contains a formula or not. It returns `TRUE` if the cell contains a formula and `FALSE` if it does not.
 How to use
ISFORMULA
formula?  Examples of using
ISFORMULA
formula ISFORMULA
formula not working? Similar formulas to
ISFORMULA
Usage
Use the ISFORMULA
formula with the syntax shown below, it has 1 required parameter:
 cell (required):
The cell that you want to check for a formula. It can be a cell reference or a range.
Examples
Here are a few example use cases that explain how to use theISFORMULA
formula in Google Sheets.
Checking for formula errors
You can use ISFORMULA
to check if a cell contains a formula error like `#DIV/0!` or `#N/A`. This can be useful when building complex formulas.
Preventing accidental overwriting of formulas
You can use ISFORMULA
in a data validation rule to prevent users from accidentally overwriting formulas in a sheet. For example, you can set a validation rule to only allow users to edit cells that do not contain formulas.
Common Mistakes
ISFORMULA
not working? Here are some common mistakes people make when using the ISFORMULA
Google Sheets Formula:
Not using a valid cell reference
One common mistake is not using a valid cell reference as the argument for ISFORMULA. Make sure to enter a valid cell reference that contains a formula.
Using a range instead of a single cell reference
Another common mistake is using a range of cells instead of a single cell reference as the argument for ISFORMULA. ISFORMULA can only be used on a single cell, so make sure to provide a valid single cell reference.
Forgetting to include the parentheses
A common mistake is forgetting to include the parentheses around the cell reference in the ISFORMULA formula. Make sure to include the parentheses to properly evaluate the formula.
Using a cell that doesn't contain a formula
ISFORMULA can only be used on a cell that contains a formula. If you use ISFORMULA on a cell that doesn't contain a formula, it will return FALSE. Make sure to use ISFORMULA on a cell that contains a formula.
Not understanding what ISFORMULA does
ISFORMULA is an information function that checks if a cell contains a formula. If the cell contains a formula, it returns TRUE. Otherwise, it returns FALSE. Make sure you understand what ISFORMULA does before using it in your sheet.
Related Formulas
The following functions are similar to ISFORMULA
or are often used with it in a formula:

ISBLANK
The
ISBLANK
formula is used to check if a cell is empty. It returnsTRUE
if the cell is empty andFALSE
if it contains any data or formula. This formula is commonly used in conditional formatting or data validation rules to ensure a cell is not left empty. 
ISTEXT
The
ISTEXT
function checks whether the value provided is a text string or not. It returns TRUE if the value is text and FALSE if it is any other data type. This function is commonly used when working with data sets that contain text and nontext values. 
ISNUMBER
The
ISNUMBER
formula is used to check if a given value is a number. It returns TRUE if the value is a number and FALSE if it is not. This formula is commonly used in data cleaning and validation to identify and remove nonnumeric values or to ensure that a cell only contains a number.
Learn More
You can learn more about the ISFORMULA
Google Sheets function on Google Support.