software

Here's what I'm wanting to do and it's driving me nuts trying to get
this setup.

I have a worksheet for calculating my Weight watchers points and
progress and such. I have almost everything working except this one
part.

I want to have it compare my total daily points (25) to my total
allowed points (28). If my total daily points are higher than my total
allow points, I would like it to calculate how many I'm over and then
subtract those from my weekly flex points (35).

I believe this is possible but I'm not sure if I'm using the correct
command.

Let me know if I didn't explain it clearly enough. --
onelinestar
------------------------------------------------------------------------
onelinestar's Profile: www.excelforum.com/member.php...oamp;userid=32826
View this thread: www.excelforum.com/showthread...hreadid=526312Daily points in A1

=35-MAX(0,A1-28)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;onelinestarquot; gt;
wrote in message
news
gt;
gt; Here's what I'm wanting to do and it's driving me nuts trying to get
gt; this setup.
gt;
gt; I have a worksheet for calculating my Weight watchers points and
gt; progress and such. I have almost everything working except this one
gt; part.
gt;
gt; I want to have it compare my total daily points (25) to my total
gt; allowed points (28). If my total daily points are higher than my total
gt; allow points, I would like it to calculate how many I'm over and then
gt; subtract those from my weekly flex points (35).
gt;
gt; I believe this is possible but I'm not sure if I'm using the correct
gt; command.
gt;
gt; Let me know if I didn't explain it clearly enough.
gt;
gt;
gt; --
gt; onelinestar
gt; ------------------------------------------------------------------------
gt; onelinestar's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32826
gt; View this thread: www.excelforum.com/showthread...hreadid=526312
gt;