# Documentation/Calc Functions/ISFORMULA

Other languages:

ISFORMULA

Information

## Summary:

Determines whether a specified cell contains a formula.

## Syntax:

ISFORMULA(Reference)

## Returns:

Returns TRUE if the specified cell contains a formula and returns FALSE otherwise.

## Arguments:

Reference is a reference to the cell that is to be tested to determine if it contains a formula.

• If Reference is not a cell reference but is an expression that evaluates to a number, a Boolean value, a date, or a string, then ISFORMULA returns the value FALSE.

## Additional details:

• ISFORMULA does not propagate errors. If Reference corresponds to a formula cell, ISFORMULA returns TRUE whatever the result of that formula (even if it is an error value).

## Examples:

Formula Description Returns
=ISFORMULA(5) Here the function returns the logical value FALSE. FALSE
=ISFORMULA(2022-01-06) Here the function returns the logical value FALSE. FALSE
=ISFORMULA(C4) where cell C4 contains the number 5. Here the function returns the logical value FALSE. FALSE
=ISFORMULA(C5) where cell C5 contains the formula =5. Here the function returns the logical value TRUE. Note that there may be no visual difference between the content of this cell and that used in the previous example. TRUE
=ISFORMULA(C6) where cell C6 contains the formula =PI()*POWER(3; 2). Here the function returns the logical value TRUE. TRUE
=ISFORMULA(C7) where cell C7 contains the formula =1/0. Here the function returns the logical value TRUE, even though cell C7 contains an error value (#DIV/0!). TRUE

## Related (or similar) Excel functions:

ISFORMULA since v.2013.