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:
Where the supplied reference argument is a reference to a cell.
Column B of the following spreadsheet shows four examples of the Excel Isformula function.
Further examples of the Excel Isformula function are provided on the Microsoft Office website.