If you want to check on the formula or the function that you used over a data, you can use another function i.e. FORMULATEXT Function.

It’s quite simple, here’s an example where the topic is described in an elaborative way:

How to show formula text with FORMULATEXT Function? 1

As you can see in the image above, we have applied a formula in the “Approved or not” column. But its hard to tell about the condition applied, or in other words, in what ways the sales data has been figured out that a particular product becomes Approved or Not approved!

Previously: Find out if a cell is THIS or THAT Using IF & OR Formula

So, here’s the deal:

How to show formula text with FORMULATEXT Function? 2

We will input the FORMULATEXT Function, which is as follows:

=FORMULATEXT(

The following formula helps us to figure out what the formula has been used. All it requires is the reference.

How to show formula text with FORMULATEXT Function? 3

As you can see in the image above, we have selected cell D2 to figure out the formula used in the same.

How to show formula text with FORMULATEXT Function? 4

As the formula only requires reference, so after selecting the same, you can shoot enter! And there you go with your answer.

The formula used behind the “Approved or not” column is:

=IF(C2>50000,”Approved”,”Not approved”)

This means, that only those products which have sales above 50000 are approved and the rest are not!

How to show formula text with FORMULATEXT Function? 5

Now you can simply drag down the FORMULATEXT Function till it is required.

It will show you the formula that was used behind the data.

How to show formula text with FORMULATEXT Function? 6

So, it’s simple, isn’t it?