In this Article

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

## ISFORMULA Function Overview

The ISFORMULA Function Test if cell is a formula. Returns TRUE or FALSE.

To use the ISFORMULA Excel Worksheet Function, select a cell and type:

(Notice how the formula inputs appear)

### ISFORMULA Function Syntax and Inputs:

=ISFORMULA(reference)

**Cell Reference** – The cell reference to the cell that you wish to test.

## 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 contain 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 |

## ISFORMULA in Google Sheets

The ISFORMULA Function works exactly the same in Google Sheets as in Excel: