Dynamic Excel Formula


S

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.
 
Ad

Advertisements

T

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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top