Excel geeks, please...
 

Okay, let me run this one through the .org.

I need to make Excel evaluate a formula that is stored as text in another cell. How can I make this happen without having to fiddle with VBA code?

Thanks in advance,

Sincerely yours,

Confused from Portugal. :confused:

Re: Excel geeks, please...
 

What? I dont even understand the question.

Re: Excel geeks, please...
 

I have a few (tens of...) formulas stored as regular text in a table. Depending on some initial conditions, I'll have to look one of them up and use it as a regular formula in another cell. The Lookup part is easy to do, but I can't find a way to get Excel to use the looked up text and use it as an actual formula.

As an example, let's say I have 2+A1 stored as text in cell A2. Now I want cell A3 to pick the contents of cell A2, which would be the text, and evaluate it as a formula (essentially the same as inputting =2+A1 in cell A3). Nope, concatenating a text string with the = sign before won't cut it... been there, done that.

Seems easy, doesn't it?... :smt108

Re: Excel geeks, please...
 

Surely you will have no problems with Excell Count von Count.....:p

http://toughpigs.com/uploaded_images...t-1-720172.jpg

Re: Excel geeks, please...
 

LOL

Re: Excel geeks, please...
 

Already solved, thank you for your time!

Re: Excel geeks, please...
 

I get the question now and its easy, but you have solved it, so no need to tell you :o)

Re: Excel geeks, please...
 

:(:(i can't use excell i'm pants sopb sob

Re: Excel geeks, please...
 

Couldn't you just have dragged the formula across into cell A3?

Re: Excel geeks, please...
 

change text cells to number cells???