Simple way to test whether a cell has a formula. Returns TRUE if the referenced cell contains a formula, and FALSE if not.

Sample Usage




  • reference - The cell or range for which you want to check whether it contains a formula or not. This can be a direct cell reference, a formula the returns a cell reference, or a name that refers to a cell. If a range is passed to this function, it will only check whether the first cell in the range has a formula.



ISFORMULA(B10) evaluates to TRUE if B10 contains =A1+B2.
ISFORMULA(B10) evaluates to FALSE if B10 contains 22 because this is a number, not a formula.


  • This function is often used with the IF function.