With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, March 9, 2013
yogi_Compute Weight Loss In Lbs And Percent Loss Over Specified Periods Of Time
Google Spreadsheet Post #1075 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Mar 9, 2013 user Doug Hood :(http://productforums.google.com/forum/?zx=nbznyz1cryoz#!mydiscussions/docs/cSL3GyzJ12A)
Realizing I'm not so good at this, I thought I would ask for assistance. I am trying to do a simple weight loss spreadsheet where you enter your weight week to week. I am also calculating the total weight lost, week to week plus a total and the percentage of weight lost week to week plus a total. I'm running into problems when some of the fields are not filled out. I have looked at the ISBLANK function but can;t get it to do what I'm looking for. Any suggestions?
I have highlight a section in green that is the desired result. The section next to it wrapped in red is what I can't get to work right. If all of the 5 weeks of weight data exist (green), all is well. But as you can see from the (red) section, the data only entered for the first two weeks with the third fourth and fifth weeks data missing, things don't turn out so well.