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.

 Formulas:
 AB
1=3+5=ISFORMULA( A1 )
2John=ISFORMULA( A2 )
3=NA()=ISFORMULA( A3 )
4999=ISFORMULA( A4 )
 Results:
 AB
1=3+5TRUE
2JohnFALSE
3=NA()TRUE
4999FALSE

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