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     www.energyefficientbuild.com.   Jul-20-2014
post by Christofer Karlsson:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/JXj3pOUIdzE)
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?

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