The Excel ISFORMULA function returns TRUE when a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.

**Syntax**:= ISFORMULA (reference)

The ISFORMULA function syntax has the following arguments:

**Reference**Required. Reference is a reference to the cell you want to test. Reference can be a cell reference, a formula, or a name that refers to a cell.

**Example**: Let’s look at some Excel ISFORMULA function examples and explore how to use the ISFORMULA function as a worksheet function in Microsoft Excel:

**Syntax**: =ISFORMULA(A2)

**Result**:

Based on the Excel spreadsheet above, the following ISFORMULA examples would return:

**Syntax**: =ISFORMULA(A3)**Result**: TRUE

**Syntax**: =ISFORMULA(A4)**Result**: TRUE

**Syntax**: =ISFORMULA(A5)**Result**: TRUE

**Syntax**: =ISFORMULA(A6)**Result**: FALSE

**Syntax**: =ISFORMULA(A7)**Result**: FALSE

**Syntax**: =ISFORMULA(A8)**Result**: TRUE

**Syntax**: =ISFORMULA(A9)**Result**: TRUE

**Syntax**: =ISFORMULA(A10)**Result**: TRUE

**Syntax**: =ISFORMULA(A11)**Result**: FALSE

**Note**:

- Empty cell can have a formula in the cell. The formula returns an empty string in the cell
- When range of cells given in as argument, the function only checks the first cell of the array as returns TRUE or FALSE based only on the first cell.
- The function returns the error if the reference to the function is invalid.