View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
onelinestar
 
Posts: n/a
Default 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