ISFORMULA Function in Google Sheets

Check if a cell contains a formula using the ISFORMULA function.

ISFORMULA Function

The ISFORMULA function in Google Sheets is used to check if a cell contains a formula.

Syntax

ISFORMULA(cell)
  • cell: The reference to the cell you want to check. This is a required parameter.

Example

  1. Formula Detection

Check if cell A1 contains a formula:

=ISFORMULA(A1)

This will return TRUE if A1 contains a formula.

Notes

  • Useful for identifying cells with dynamic content.
  • Can be combined with conditional formatting to highlight cells containing formulas.
  • ISTEXT: Check if a cell contains text.
  • ISNUMBER: Check if a cell contains a numeric value.