SV650.org - SV650 & Gladius 650 Forum

SV650.org - SV650 & Gladius 650 Forum (http://forums.sv650.org/index.php)
-   Idle Banter (http://forums.sv650.org/forumdisplay.php?f=116)
-   -   Excel geeks, please... (http://forums.sv650.org/showthread.php?t=116562)

Filipe M. 28-08-08 01:05 PM

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:

Viney 28-08-08 01:25 PM

Re: Excel geeks, please...
 
What? I dont even understand the question.

Filipe M. 28-08-08 01:31 PM

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

Tomtoms 28-08-08 01:33 PM

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

Filipe M. 28-08-08 01:34 PM

Re: Excel geeks, please...
 
Quote:

Originally Posted by Tomtoms (Post 1607535)
Surely you will have no problems with Excell Count von Count.....:p

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

LOL

Filipe M. 28-08-08 01:45 PM

Re: Excel geeks, please...
 
Already solved, thank you for your time!

Viney 28-08-08 02:05 PM

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

BernardBikerchick 28-08-08 02:07 PM

Re: Excel geeks, please...
 
:(:(i can't use excell i'm pants sopb sob

joshmac 28-08-08 03:42 PM

Re: Excel geeks, please...
 
Couldn't you just have dragged the formula across into cell A3?

anna 28-08-08 04:21 PM

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.