ISFORMULA Function in Excel – Test if the cell contains formula

ISFORMULA Function in Excel tests if a supplied cell has formula in it. If the supplied cell has any formula then ISFORMULA Function returns TRUE, if not the function returns FALSE.

Syntax of ISFORMULA Function in Excel:

ISFORMULA(reference)

Where reference argument is the reference to the cell.

 

Example of ISFORMULA Function in Excel:

Formula

ISFORMULA Function in Excel 1

  • The above example takes up values as input and returns TRUE only if the supplied value in the cell has formula, otherwise the function returns FALSE

Result:

ISFORMULA Function in Excel 2

previous-small ISFORMULA Function in Excel                                                                                                                 next_small ISFORMULA Function in Excel