## How to use the ISFORMULA function

**What is the ISFORMULA function?**

The ISFORMULA function returns TRUE if a cell contains a formula, FALSE if cell contains text, number, Boolean value, or is empty.

**What is a formula?**

A formula in Excel is an expression that calculates a value based on the values in other cells. Formulas must start with an equals sign "=" and can contain cell references, math operators, functions, constants, arrays, etc. They are used to perform calculations in Excel.

**What is a Boolean value?**

A Boolean value in Excel is a value that can only be TRUE or FALSE. It represents binary logic and is the result of a logical expression using logical operators or a result of a few Excel functions.

Mastering Boolean logic and logical expressions is key to manipulating data and controlling workflow in Excel.

**What is a text value?**

A text value is a value that contains at least one nonnumeric character, for example "hello" without double quotes. Text values are left-aligned in cells, this can however be changed by formatting cells.

**What is a number?**

For Excel to identify a cell value as a number all characters must be numeric digits. Numbers are right-aligned in cells, this can be changed by formatting cells.

**Other IS functions**

Excel Function | Description |
---|---|

ISBLANK(value) | Returns TRUE if the value is empty, FALSE otherwise |

ISERR(value) | Returns TRUE if the value is any error value except #N/A, FALSE otherwise |

ISERROR(value) | Returns TRUE if the value is any error value, FALSE otherwise |

ISEVEN(value) | Returns TRUE if the value is an even number, FALSE for odd numbers |

ISFORMULA(reference) | Returns TRUE if the cell contains a formula, FALSE otherwise |

ISLOGICAL(value) | Returns TRUE if the value is a logical value (TRUE/FALSE), FALSE otherwise |

ISNA(value) | Returns TRUE if the value is the #N/A error, FALSE otherwise |

ISNONTEXT(value) | Returns TRUE if the value is not text, FALSE if it is text |

ISNUMBER(value) | Returns TRUE if the value is a number, FALSE otherwise |

ISODD(value) | Returns TRUE if the value is an odd number, FALSE for even numbers |

### ISFORMULA function Syntax

ISFORMULA(*reference*)

### ISFORMULA function Arguments

reference |
Required. The cell you want to check for a formula. |

**What is a cell reference?**

A cell reference lets you "fetch" and use values in other cells in a formula.

There are two types of cell references:

- A1-style reference
- R1C1 reference

The A1-style reference is the default style in Excel, it names columns by letters from A to Z. After Z it starts over with AA, AB, and so on until XFD. Rows are numbered from 1 to 1048576, older Excel versions use less row numbers.

The R1C1-style uses row number and column number like: R1C1, R2C5 and R10C15. Rows are labeled R1, R2, R3 and so on, columns are labeled C1, C2, C3 etc.

The A1-style reference notation is the most common one, here are some examples:

A1 - single cell reference on the same worksheet

A1:D5 - reference to a cell range on the same worksheet

Budget!Z3 - a single cell reference to worksheet Budget

'Budget 2050'!A3 - a single cell reference to a worksheet containing a space character

There are two types of cell references:

- Relative cell references
- Absolute cell references

The examples above are all relative cell references, they change accordingly if a cell is copied and pasted to another cell which absolute cell references do not.

The $ dollar character lets you an absolute cell reference meaning you can lock a cell reference horizontally, vertically or both. Here is one example:

A$1 has a relative column reference but an absolute row reference, this means that the column letter may change if the cell is copied and pasted to cells in another column than A.

### ISFORMULA function example

Formula in cell D3:

### ISFORMULA function not working

Keep in mind, the ISFORMULA function returns TRUE even if the formula returns an error.

### 'ISFORMULA' function examples

The following article has a formula that contains the ISFORMULA function.

This article demonstrates how to find empty cells and populate them automatically with a formula that adds numbers above and […]

### Functions in 'Information' category

The ISFORMULA function function is one of many functions in the 'Information' category.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form