Alex Rivera | Logout

How to turn a string formula into a "real" formula?

Asked 2010-12-17T15:17:28.207
94

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?

Edit
Report

1 Answer

12

Just for fun, I found an interesting article here, to use a somehow hidden evaluate function that does exist in Excel. The trick is to assign it to a name, and use the name in your cells, because EVALUATE() would give you an error msg if used directly in a cell. I tried and it works! You can use it with a relative name, if you want to copy accross rows if a sheet.

answered 2010-12-17T16:16:31.983

Your Answer