# Documentation/Calc Functions/ISFORMULA

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

ISFORMULA

## Category:

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 LibreOffice functions:

## ODF standard:

## Related (or similar) Excel functions:

ISFORMULA since v.2013.