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 MI    Mar 9, 2013
user Doug Hood :(!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?

Weight Lbs lost % lost
207.0 5.0     2.4
       207.0         100.0
       0.0         #DIV/0!
       0.0        #DIV/0!
        212.0 #DIV/0!

Attachments (1)
4 KB   View   Download

Not sure if I am sharing this correctly but here is the link.

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.
here we go