Comparing numbers and subtracting from a total
 

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: http://www.excelforum.com/member.php...o&userid=32826
View this thread: http://www.excelforum.com/showthread...hreadid=526312

Comparing numbers and subtracting from a total
 

Daily points in A1

=35-MAX(0,A1-28)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"onelinestar"
wrote in message
...

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:
http://www.excelforum.com/member.php...o&userid=32826
View this thread: http://www.excelforum.com/showthread...hreadid=526312