Skip to content
Google Sheets

ISFORMULA function in Google Sheets

Checks whether a formula is in the referenced cell.

=ISFORMULA(cell)

ISFORMULA syntax and parameters

One argument, one required.

  • cellrangeRequired

    The cell to check for a formula. ISFORMULA returns TRUE if cell is a cell that contains a formula. If cell contains a range of cells then TRUE will be returned if the first cell in the range contains a formula. All other values will return FALSE.

ISFORMULA examples

Formulas you'll actually reuse.

  1. Spot hard-coded values in a column that should be formulas:

    =IF(ISFORMULA(C2), "calculated", "typed")

    Result"typed"

  2. How many cells in the totals column were overwritten by hand:

    =SUMPRODUCT(--NOT(ISFORMULA(C2:C200)))

    Result2

ISFORMULA in Excel

Same name — your formula ports as-is.

Try ISFORMULA in the playground

Edit the example — nothing to install.

Preloaded with the ISFORMULA formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.