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!

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]