Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Isformula-Function

The Excel ISFORMULA Function

Related Functions:
ISERROR Function
ISLOGICAL Function
ISNUMBER Function
ISREF Function
ISTEXT 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.

 Formulas:
  A B
1 =3+5 =ISFORMULA( A1 )
2 John =ISFORMULA( A2 )
3 =NA() =ISFORMULA( A3 )
4 999 =ISFORMULA( A4 )
 Results:
  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.

Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions