Comparing numbers and subtracting from a total

  • Thread starter Thread starter onelinestar
  • Start date Start date
O

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. :)
 
Back
Top