# ISFORMULA Function Examples – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023

This tutorial demonstrates how to use the ISFORMULA Function in Excel to test if a cell contains a formula.

## How to use the ISFORMULA Function

The ISFORMULA Function tests if a cell contains a formula. If the cell contains a formula it returns TRUE, otherwise it returns FALSE.

``=ISFORMULA(A2)``

### If Is Formula

Usually, after performing a logical test, you will want to do something based on the result of that test. The IF Function can be used to perform different actions if a statement is evaluated as TRUE or FALSE. Let’s use it with the ISFORMULA Function.

``=IF(ISFORMULA(A2),"formula", "not formula")``

### FORMULATEXT Function

The FORMULATEXT Function converts a cell formula to text. However, if the cell does not contain a formula, FORMULATEXT will throw an error. This is a great opportunity to use the ISFORMULA Function.

``=IF(ISFORMULA(A2),"formula", "not formula")``

In this example, we use the ISFORMULA Function to test if a cell contains a formula. If so, it will output the formula as text with the FORMULATEXT Function. If not, it will output the cell value.

### If Is Not Formula

The NOT Function inverts logical results. It changes TRUE to FALSE and FALSE to TRUE. Here we can use NOT, alongside the ISFORMULA and IF Functions.

``=IF(NOT(ISFORMULA(A2)),"not formula", "formula")``

### Other Logical Functions

Excel / Google Sheets contain many other logical functions to perform other logical tests. Here is a list:

IF / IS Functions
iferror
iserror
isna
iserr
isblank
isnumber
istext
isnontext
isformula
islogical
isref
iseven
isodd