IsFormula Function in Excel 2013

This is a new function introduced in Excel 2013. This function is used to determine whether the formula is applied or not on a particular cell. The return type of this function is boolean. If the formula is applied on the the cell then it returns true otherwise false.

The syntax of the Isformula() function is ISFUNCTION(reference).

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now select blank workbook template from the available templates.


Step 3

Now enter some data in the cells applying the formula on the data.


Step 4

Now to determine whether the particular cell contains a formula or not. To do that we will give a heading to the column named ISFORMULA like this:


Step 5

Now we will use the isformula() function like this:


Step 6

The output will be like this:


Step 7

Now to determine the formula status of other cells we will select the first cell in which the result is appearing and drag the cursor following the hotspot.


Step 8

The output will be like this: