# ISFORMULA

Formulas / ISFORMULA
Test if a cell contains a formula.
`ISFORMULA(reference)`
• reference - a reference to the cell to test

## Examples

• `=ISFORMULA(A1)`

The ISFORMULA function can be used to check if a particular cell contains a formula. For example, this returns TRUE if cell A1 contains a formula.

• `=ISFORMULA(A1="=2+2")`

The function can also be used to check if a cell contains a specific formula. For example, this would return TRUE if cell A1 contains the formula "=2+2".

• `=ISFORMULA(A1="{=SUM(A2:A10)}")`

The ISFORMULA function can also be used to check if a cell contains an array formula. For example, this would return TRUE if cell A1 contains the array formula "{=SUM(A2:A10)}".

• `=ISFORMULA("Hello World")`

The ISFORMULA function can also be used to check if a cell contains a text string. For example, this would return FALSE because the argument is the text string "Hello World".

## Summary

The ISFORMULA function is a useful tool that quickly checks if a cell contains a formula. It can be used to verify that formulas are properly entered and functioning.

• ISFORMULA returns TRUE if a cell contains a formula and always returns TRUE regardless of the formula's output or error conditions.
• ISFORMULA takes one argument, reference, which must be a cell reference.

What is the ISFORMULA function?
The ISFORMULA function is a type of Sourcetable function that returns TRUE if there is a formula in a cell reference.
How do I use the ISFORMULA function?
To use the ISFORMULA function, you must use the following syntax: ISFORMULA(reference). The reference is a cell reference that you want to check for whether or not it contains a formula. The function will return either TRUE or FALSE depending on whether or not there is a formula in the cell.
What are some examples of using the ISFORMULA function?
• You can use the ISFORMULA function to check if cells in a range contain a formula. For example, you can use the ISFORMULA function to check if cells A1 to A10 contain a formula by entering the following into a cell: ISFORMULA(A1:A10). This will return TRUE if any of the cells in the range contain a formula.
• You can use the ISFORMULA function to check if a specific cell contains a formula. For example, if you want to check if cell A1 contains a formula, you can enter the following into a cell: ISFORMULA(A1). This will return TRUE if the cell contains a formula.
What is the output of the ISFORMULA function?
The output of the ISFORMULA function is either TRUE or FALSE. It will return TRUE if the cell reference contains a formula and FALSE if the cell does not contain a formula.