Sunday, July 20, 2014

yogi_Evaluate A String With Multiplication And Addition Operators In Order As Shown

                                Google Spreadsheet   Post  #1701
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul-20-2014
post by Christofer Karlsson:
Calculate content in another cell
This is most likely a day one beginner class question, but I've searched and searched and apparently can't figure it out on my own.

Let's say I have a cell with the content "2*2+2" (without the quotes). If I want to calculate it in the same cell it's a piece of cake with a ”=" in front, but how do I set it up if I want to calculate it in another cell?

As of now (Jul-20-2014) Google spreadsheet does not have an EVAL() function, so in the following I present my convoluted solution