 |
 |
Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
 |
|
|
Thread Tools |
28-08-08, 01:05 PM
|
#1 |
|
Guest
Posts: n/a
|
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. 
|
|
|
28-08-08, 01:25 PM
|
#2 |
|
Member
Mega Poster
Join Date: Jul 2003
Location: In the shadows to the left
Posts: 7,700
|
Re: Excel geeks, please...
What? I dont even understand the question.
|
|
|
|
28-08-08, 01:31 PM
|
#3 |
|
Guest
Posts: n/a
|
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?... 
|
|
|
|
28-08-08, 01:33 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: Excel geeks, please...
Surely you will have no problems with Excell Count von Count.....
 http://toughpigs.com/uploaded_images...t-1-720172.jpg |
|
|
|
28-08-08, 01:34 PM
|
#5 | |
|
Guest
Posts: n/a
|
Re: Excel geeks, please...
Quote:
|
|
|
|
|
28-08-08, 01:45 PM
|
#6 |
|
Guest
Posts: n/a
|
Re: Excel geeks, please...
Already solved, thank you for your time!
|
|
|
|
28-08-08, 02:05 PM
|
#7 |
|
Member
Mega Poster
Join Date: Jul 2003
Location: In the shadows to the left
Posts: 7,700
|
Re: Excel geeks, please...
I get the question now and its easy, but you have solved it, so no need to tell you
 )
|
|
|
|
|
28-08-08, 02:07 PM
|
#8 |
|
Guest
Posts: n/a
|
Re: Excel geeks, please...
 i can't use excell i'm pants sopb sob
|
|
|
|
28-08-08, 03:42 PM
|
#9 |
|
Guest
Posts: n/a
|
Re: Excel geeks, please...
Couldn't you just have dragged the formula across into cell A3?
|
|
|
|
28-08-08, 04:21 PM
|
#10 |
|
Member
Mega Poster
Join Date: Aug 2005
Location: Tower Hamlets but with Shutters on the windows
Posts: 1,522
|
Re: Excel geeks, please...
change text cells to number cells???
|
|
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel | Graciepants | Idle Banter | 15 | 31-03-09 10:52 PM |
| Some basic HELP with EXCEL pls | 600+ | Idle Banter | 4 | 02-10-07 01:59 PM |
| Another one for the Excel gurus | Jelster | Idle Banter | 6 | 12-06-07 08:48 AM |
| Excel Question | Tris | Idle Banter | 4 | 04-04-07 11:42 AM |
| Excel question | nickj | Idle Banter | 3 | 04-09-06 12:35 PM |
