Author: Oscar Cronquist Article last updated on April 17, 2018

The ISFORMULA function returns TRUE if a cell contains a formula, FALSE if text, number or boolean value.

Formula in cell D3:

=ISFORMULA (B3)

Excel Function Syntax

ISFORMULA(reference)

Arguments

reference Required. The cell you want to check for a formula.

Comments

Keep in mind, the ISFORMULA function returns TRUE even if the formula returns an error.