I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?
0,4*A1
Evaluate might suit:
Evaluate
http://www.mrexcel.com/forum/showthread.php?t=62067
Function Eval(Ref As String) Application.Volatile Eval = Evaluate(Ref) End Function
1.4m articles
1.4m replys
5 comments
56.9k users