Return Formula As String In Excel

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.

Capture

Use FORMULATEXT function column B as shown below, it takes a single argument as an input.




Enter the formula in B2 and B3.

Capture

As you could see the formula behind the result is shown

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply