String to formula

joyrock37

New Member
Joined
Oct 14, 2011
Messages
26
Hi friends,

I have the following task:

Cell A1 contains the string "4,4*EXP(0,03*".
Cell B1 contains a numeric value which can be changed.
Cell C1 concatenates the two strings: = A1&B1&")" to string that Looks like a formula.

In Cell D1, I would like to get the result of the string in Cell C1.

I prefer a standard Excel-function of some sort, but haven't been able to find anything that worked for me.

So I tried:
Function Eval(Ref As String)
Application.Volatile
Eval = Evaluate(Ref)
End Function

But the function Returns #Value !

Big Thanks for your help and suggestions!
 
Hi FormR,

it actually worked now also with your first suggestion, I just had to use the german Version of "Substitute"....
Kudos to you - Great help!
 
Upvote 0

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,226,695
Messages
6,192,478
Members
453,727
Latest member
tuong_ng89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top