How to use ISFORMULA Function in Excel

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:

ISFORMULA Function - How to use ISFORMULA Function in Excel

Syntax:  =ISFORMULA(A2)

Result:

ISFORMULA Function in Excel - How to use ISFORMULA Function in Excel

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:

  1. Empty cell can have a formula in the cell. The formula returns an empty string in the cell
  2. 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.
  3. The function returns the  error if the reference to the function is invalid.
READ:  How to use SHEET Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *