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.

Frequently Asked Questions

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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV