Let’s see how to return a formula as string or formula as text in excel.
We often come across a situation where we want to display the formula behind the result in a cell side by side and we have to do it manually.
FORMULATEXT () function in excel takes care of the problem.
The function returns the formula as text which you can use to display o manipulate as string.
Suppose we are interested in seeing the formula which is behind the results calculated below.
Use FORMULATEXT function column B as shown below, it takes a single argument as an input.
Enter the formula in B2 and B3.
As you could see the formula behind the result is shown
Hope this helped.