Skip to main content

ISFORMULA function

The ISFORMULA function is one of the information functions. It is used to check whether there is a reference to a cell that contains a formula. If the cell contains a formula, the function returns TRUE, otherwise the function returns FALSE.

Syntax​

ISFORMULA(reference)

The ISFORMULA function has the following argument:

ArgumentDescription
referenceA reference to a cell that you want to test.

Notes​

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the ISFORMULA function.

Examples​

The figure below displays the result returned by the ISFORMULA function.

ISFORMULA Function