The Excel ISFORMULA Function

Function Description

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

Note: the Isformula function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

ISFORMULA( reference )

Where the supplied reference argument is a reference to a cell.

Isformula Function Examples

Column B of the following spreadsheet shows four examples of the Excel Isformula function.

  A B
1 =3+5 =ISFORMULA( A1 )
2 John =ISFORMULA( A2 )
3 =NA() =ISFORMULA( A3 )
4 999 =ISFORMULA( A4 )
  A B
1 =3+5 TRUE
2 John FALSE
3 =NA() TRUE
4 999 FALSE

For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.