![]() |
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...
Quote:
|
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???
|
All times are GMT. The time now is 09:22 PM. |
Powered by vBulletin® - Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.