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:
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!
So, here’s the deal:
We will input the FORMULATEXT Function, which is as follows:
The following formula helps us to figure out what the formula has been used. All it requires is the reference.
As you can see in the image above, we have selected cell D2 to figure out the formula used in the same.
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:
This means, that only those products which have sales above 50000 are approved and the rest are not!
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.
So, it’s simple, isn’t it?