Convert text to Formula in Excel 2007

[sma.bakker]

Hello Forum,

I need to build interactive formulas as part of a bigger table.

I have come only this far with the test model:

A1 1 (or any value)
B1 + (or any operator)
C1 2 (or any value)
D1 =1+2 as the result of ="="&A1&B1&C1 in text format

Now I want E1 to show the result. In this case a total of 3

How can I convert D1 to a formula in E1 that calculates the result and changes with any of the input values? I have spend ours on it without results . Can something this simple be that complex; PLEASE

Sebastiaan

 

[GlennUK]

What do you mean? This thread is about performing string versions of mathematical formulas. What does that have to do with references? If you are asking about doing INDIRECT referencing to closed workbooks, then use the MOREFUNC download and it's INDIRECT.EXT function.

 

[jadexyj]

I am working on company's computer, I can't install the add-on myself, looks like I need to write some code in excel in order to use this EVALUATE function?

Never did write code before......

 

[GlennUK]

Explain precisely what you are trying to achieve.