**Rational**

Check if a cell contains a formula

**Description**

The Excel ISFORMULA function check if a specified cell is containing a formula and returns “TRUE” when a cell consists of formula, and “FALSE” when a cell does not have a formula.

For example cell C6 contains =2+2, “=ISFORMULA(C6)” returns TRUE as the cell containing a formula.

**Syntax**

=ISFORMULA( reference )

**Parameters**

**value – **Refer cell to check if contain a formula.

**Return Value**

A Boolean value (TRUE or FALSE)

**Key Notes**

- The ISFORMULA cell is useful in finding a formula or blank cell within a large data set.
- ISFORMULA function returns the #VALUE! error value in case reference is not a valid data type.
- The ISFORMULA formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

## Keep Reading Similar Functions:

### ISBLANK

The ISBLANK function checks if a cell is blank and returns “TRUE” when it is, I.e., “=ISBLANK(“Text”)” return FALSE as the cell contains some value “Text”.

### ISLOGICAL

The ISLOGICAL function check if a specified cell has Boolean value and returns “TRUE” when a cell has a Boolean data type, and “FALSE” if it does not.

### ISREF

The ISREF function checks if a cell has a correct reference, returns “TRUE” when a cell has a valid reference, and “FALSE” for reference error or not linked.