Dynamic Excel Formula

[santosh]

Hello, just wondering if there is an easy way to do this.
I have a list of formulas that I generated in one column.

I want the adjacent column cell to have the "executed" result of that
formula.
Is there an easy way to do that?

Thank you.

 

[trip_to_tokyo]

Hello, just wondering if there is an easy way to do this.
I have a list of formulas that I generated in one column.

I want the adjacent column cell to have the "executed" result of that
formula.
Is there an easy way to do that?

Thank you.

Assuming that your formula is in cell B11.

In cell C 11 type:-

=B11

Copy as required.

If possible please rate my posting.

Thanks.

 

[Gord Dibben]

By "list" do you mean the formulas written as text?

How about in adjacent column enter the same formula not written as text?

Or the other way around

Enter your results formulas in Column B

Use this UDF in column A to show formulas that returned results in column B

Function ShowFormula(Cell)
Application.Volatile
ShowFormula = "No Formula"
If Cell.HasFormula Then ShowFormula = Cell.Formula
End Function


Gord Dibben MS Excel MVP