convert string to formula

Hello everybody,

I'm trying to make code for calculation from string. I want to write a general formula into cell A1 - example: (F+H)/2 or (G-I+3)*2. Everything is in Form.

1. step - analize of formula

Please Login or Register  to view this content.

step 2. - result
when formula in cell A1 is (F+G)/2 and myvalue1 = 5 and myvalue2 = 3 -> I get string myformula = (5+3)/2

step 3. - question
Would anyone know and help, how to calculate this "formula" and get myvalue10 = result of myformula?
myvalue10 is in Form too (not written to cell as formula)

Thanks

Martin

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

Please Login or Register  to view this content.

perhaps your formula string is incorrect.