# Excel ISFORMULA function

## Summary

The Excel ISFORMULA function checks if a specific cell contains a formula. This function is useful for auditing spreadsheets, identifying cells with formulas, and implementing conditional formatting or logic based on whether a cell’s value is calculated or manually entered.
##### Syntax
```				```
=ISFORMULA(reference)
```
```
• reference: The cell reference you want to check for a formula
##### Return value
• TRUE if the specified cell contains a formula
• FALSE if the cell does not contain a formula

## How to use

ISFORMULA is straightforward to use: simply provide the cell reference you wish to check. It can be particularly useful in conjunction with other functions like IF to perform different actions depending on whether or not a cell contains a formula.

## Examples

##### Simple ISFORMULA
Identifying Cells with Formulas: To determine if a cell, such as A1, contains a formula.
```				```
=ISFORMULA(A1)

```
```
If A1 has a formula, this returns TRUE, indicating the presence of a formula. If A1 is empty or contains a constant value (like text or a number), it returns FALSE.
##### ISFORMULA with Conditional Logic
Creating Conditional Messages Based on Formula Presence: Using ISFORMULA within an IF statement to provide feedback about a cell’s content.
```				```
=IF(ISFORMULA(A1), "Contains formula", "No formula")

```
```
This formula checks if A1 contains a formula and returns “Contains formula” if true; otherwise, it says “No formula”, helping users understand the nature of the cell’s content at a glance.
##### ISFORMULA with INDIRECT
Verifying Formula Existence in a Dynamic Cell Reference: To dynamically check if a referenced cell contains a formula using INDIRECT.
```				```
=ISFORMULA(INDIRECT("B" & A1))

```
```
Assuming A1 contains a row number, this formula uses INDIRECT to construct a reference to a cell in column B and then checks if that cell contains a formula.