Test if a cell contains a formula.

`ISFORMULA(reference)`

- reference - a reference to the cell to test

`=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".

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.

The ISFORMULA function is a type of Sourcetable function that returns TRUE if there is a formula in a cell reference.

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.

- 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.

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.

Drop CSV