A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formula Layout Excel



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2004, 03:22 PM
Thor's Castle
external usenet poster
 
Posts: n/a
Default Formula Layout Excel

Anybody know how to convert this formula so it woks in excel please?



The actual Weight Watchers Points formula used in the Weight Watchers Points
calculator is currently under strict US Patent laws. The formula is shown
below::






Attached Images
File Type: gif weight-watchers-points-form.gif (4.0 KB, 67 views)
  #2  
Old March 16th, 2004, 03:26 PM
JulieD
external usenet poster
 
Posts: n/a
Default Formula Layout Excel

Hi

Assuming the following

"c" is in cell A2, "f" is in cell "B2", "r" is in cell C2 and "p" is
required in cell D2

this should give you what you want

=(a2/50)+(b2/12)-(min(C2,4)/5)

Hope this helps

Cheers
JulieD

"Thor's Castle" wrote in message
...
Anybody know how to convert this formula so it woks in excel please?



The actual Weight Watchers Points formula used in the Weight Watchers

Points
calculator is currently under strict US Patent laws. The formula is shown
below::







  #3  
Old March 16th, 2004, 04:53 PM
Lady Layla
external usenet poster
 
Posts: n/a
Default Formula Layout Excel

Search on Google for this. I have seen many examples of WW point trackers in
Excel out there


"Thor's Castle" wrote in message
...
: Anybody know how to convert this formula so it woks in excel please?
:
:
:
: The actual Weight Watchers Points formula used in the Weight Watchers Points
: calculator is currently under strict US Patent laws. The formula is shown
: below::
:
:
:
:
:


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.