The ISFORMULA function tests if a specified cell contains a formula, and if so, returns TRUE; Otherwise, the function returns FALSE.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=ISFORMULA(cell_ref)

Arguments

Argument Description
cell_ref The cell_ref argument is a reference to a cell

Examples

  A B C
1   Formula Result
2 =3+8 =ISFORMULA(A2) TRUE
3 Joseph =ISFORMULA(A3) FALSE
4 =NA() =ISFORMULA(A4) TRUE
5 198 =ISFORMULA(A5) FALSE