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.

isformulainexcel1.jpg

Step 3

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

isformulainexcel2013.jpg

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:

excel2013isformula.jpg

Step 5

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

isformulafunctionexcel.jpg

Step 6

The output will be like this:

isformulainexcel.jpg

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.

excel2013isformulafunction.jpg

Step 8

The output will be like this:

 isformulafunctioninexcel2013.jpg


Similar Articles