Comparing numbers and subtracting from a total

[onelinestar]

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.

 

[Peo Sjoblom]

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" <[email protected]>
wrote in message
news[email protected]...