# Cannot get formula for Weight Watcher Points Plus to work

#### vkirchner

##### New Member
Firts let me say thank you for any help you can lend, I am not an Excel expert by any means. Just a simple noob that can add a few number together or simple math calculations. I am trying to use a formula to calculate Weight Watcher Points Plus for my Wifes website, she is getting ready to go online with her cookie business and we would like to display the older Weight Watcher Points and also the newer Plus formula results that started in 2011.

The formula provided is as follows as supplied by Wikipedia.

Which is also displayed as:

pp =max{ round( [ (16xp) + (19xc) + (45xf)- (14xr)] /175), 0}

pp - Weight watchers points plus
p- Protein
t - Carbohydrates
f - Fat
r - Dietary fiber

My cells for the values are:

Protein - D26
Carbohydrates - F26
Fat - G28
Fiber - M26

When I type in the formula as provided, it stops immediately at the MAX stating that I have an error and to look at the help documents which unfortunately is not a help to me. I am using Office 2010 version in case that make a difference in the functions. I would appreciate any help with this.

Regards
Vince

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Try this:

=MAX(ROUND((16*D26+19*F26+45*G28+14*M26)/175,0),0)

The problem is that max doesn't make sense to use in your formula. Max brings back the highest value of 2 or more numbers. So the max of 5, 10, 15 is 15. Now your formula before it reaches the max part only has 1 number. That is why you get an error.

Correction:

=MAX(ROUND((16*D26+19*F26+45*G28-14*M26)/175,0),0)

The formula works, thank you very much. The values are higher than previous point values, if I was counting the point values, I think I would use the old system to get more to eat, I hope their total points for the day also went up. LOL! Again gentlemen, thank you.

You are most welcome.

I agree that there is no need for the MAX in that formula, but MAX is happy with just one argument.

I think the MAX is there to protect against negative values deriving from high fiber items.

1,219,936
Messages
6,151,066
Members
451,006
Latest member
dhinze84

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back