Reader Level:

IsFormula Function in Excel 2013

By Megha Goyal on Aug 30, 2012
In this article we will discuss about how to use the 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:




JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.

Trending up

Infragistics jQuery Controls