Is it possible to use formulas indirectly based on text?

[tahi.laci]

Let's say in the value of A1 = "SUM(2, 4)/2". I would like to put a formula in another cell which would evaluate this text with an "=" in the front.

Let's say the function I'm looking for is in A2. In this case the value in A2 is supposed to be 3, however if the value of A1 changes to "SUM(2, 4)/2+1" the value of A2 is supposed to change to 4.

I could do this with a macro but it would be more convenient if it was possible to do with a function.

[Ron Coderre]

You could use an ancient Excel4 macro command, instead of VBA.
A1: SUM(2,4)/2

• Formulas.Name_Manager...click: New
...Name: MyCalcVal
...Refers to: =EVALUATE(Sheet1!$A$1)
...Click: OK

Next...
A2: =MyCalcVal
The result will be: 3

Is that any approach you could use?

[tahi.laci]

I didn't fully understand your answer, however after some search I found out that the EVALUATE function can be part of a user defined function like this

Please Login or Register  to view this content.

With that in place I put A2: "=eval(A1)" and my problem is solved. , Thanks