3 Fat Chicks on a Diet Weight Loss Community

3 Fat Chicks on a Diet Weight Loss Community (https://www.3fatchicks.com/forum/)

- WW Food and Point Issues (https://www.3fatchicks.com/forum/ww-food-point-issues-23/)

- - Points Formula again (https://www.3fatchicks.com/forum/ww-food-point-issues/18604-points-formula-again.html)

YoyosMa

07-29-2002 08:56 PM

Points Formula again

Ok, I'm a bit confused here. Writing a formula for MS Access.

If you write a formula that minuses one point for every 5 grams of fiber, great. But since we can only use 4 points, how does this work in the formula? How do you ever get one point taken off? Plus, how do you get formula to only calculate 4 points if you've put in 6?

So many questions!

Kelly_S

07-30-2002 10:17 AM

Points Formula (from the actual patent W/W has):

[(Calories/50) + (Fat Grams/12) -(Fiber Grams <capped at 4 for Winning Points>/5) = POINTS]

So say you have 120 cal/0 fat/0 fiber it would be

[(120/50) + (0/12) - (0/5) = 2.4]

If you have 660 cal/33 fat/12 fiber

[(660/50) + (33/12) - (4/5) = 20.15]

All times are GMT -4. The time now is 06:41 PM.