ISFORMULA function

The ISFORMULA function in Excel checks if a cell contains a formula. It returns TRUE if the specified cell contains a formula and FALSE if it does not.

Syntax:

ISFORMULA(reference)

Arguments:

• reference: The cell reference that you want to check for a formula.

Example:

Example 1: Cell contains a formula

• Data in A1: =SUM(B1:B5)
• Formula:

  =ISFORMULA(A1)
  

• Result: TRUE (since cell A1 contains a formula).

Example 2: Cell contains a value, not a formula

• Data in B1: 10
• Formula:

  =ISFORMULA(B1)
  

• Result: FALSE (since cell B1 contains a static value, not a formula).

Key Points:

1. Formula vs. Value:
   • ISFORMULA detects whether the cell contains a formula (even if it results in a static value).
   • If the cell contains a value (like a number or text), ISFORMULA returns FALSE.
2. Error Handling:
   • If the reference is invalid (for example, a deleted or non-existent cell), ISFORMULA may return an error.
3. Cell References:
   • ISFORMULA works with direct cell references or ranges, but the result is based on individual cell content.

Use Cases:

1. Formula Detection:
   • Identify whether a cell contains a formula before performing further calculations.

   =IF(ISFORMULA(A1), "Formula Present", "No Formula")
   

2. Debugging:
   • Use ISFORMULA in combination with other functions (like ISNUMBER) to differentiate between values and formulas in complex sheets.