ISFORMULAformula 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
- Examples of using
ISFORMULAformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
ISFORMULAformula 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.
ISFORMULAnot working? Here are some common mistakes people make when using the
ISFORMULAGoogle 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.
The following functions are similar to
ISFORMULA or are often used with it in a formula:
ISBLANKformula is used to check if a cell is empty. It returns
TRUEif the cell is empty and
FALSEif 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.
ISTEXTfunction 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 non-text values.
ISNUMBERformula 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 non-numeric values or to ensure that a cell only contains a number.
You can learn more about the
ISFORMULA Google Sheets function on Google Support.