How to Make a Weight Watchers Points Calculator with Excel
The formula for weight watchers points is to divide the total calories by 50, divide the number of fat grams by 12, and add those two numbers. Then divide the number of fiber grams by 5 and subtract that. This gives you the points value of a food. These formulas can be easily put into an excel sheet and saved, so that you only have to enter the calories, fat and fiber and the calculation is done. A free points calculator!
Instructions
-
-
1
Open a new excel file.
In the first column in row 5, type Calories, then in row 6 type Fat grams,
then skip a line and in row 8 type Fiber.
So you have typed "calories" in cell A5, "Fat grams" in cell A6, and "Fiber" in cell A8. -
2
In the next column, highlight the three cells that are next to the words you typed, and color block them. These are the sells where you will type in the values you want to convert to points. The color blocking will remind you where to enter the values.
-
-
3
In the third column, in cell C5, type the following formula: =B5/50 then enter.
In cell C6, type the following: =B6/12 then enter.
Then go back to cell C6 and type Ctrl U, or click on the underline tool on the toolbar. -
4
In cell C7, use the 'sum' function, or type =C5+C6 to total the two cells.
You can test it at this point by entering numbers in the B column. Try typing 100 in cell B5, and 6 in cell B6. Your sum should be 2.5 if your formulas are correct. -
5
In cell C8, type =B8/5
Then go back and underline that also (Ctrl + u).
Then in C9, type =ROUND(C7-C8,0)
That will round the points number for you. -
6
Name it and save it! That's it. Grab a package with a nutritional label and try it out. Be sure to enter in the highlighted boxes only. You might want to put a note somewhere on the page reminding you where you enter the values.
-
1
