Running Total Maximum?

  • Thread starter Thread starter Mr. X
  • Start date Start date
M

Mr. X

I am looking for a method to have a running total of percentages and
have it cap out at a certain number.

If I use something like this..

=IF(SUM(SheetName!B529,SheetName!B533)>275,(SUM(SheetName!B529,SheetName!B533)),2.75)

then it only works on cells that have already reached 275 and it only
works on cells lower than 275 if I reverse > to this <

So that is why I am thinking if I have a method to reach a maximum of
275, it would allow it to work for all cells.

I have searched newsgroups, etc. and have not been able to find an
answer.
 
I'm not sure I'm clear on exactly what you're looking for, but perhaps the
MIN function will work for you:

=MIN(SUM(SheetName!B529,SheetName!B533),275)

This will return the lower of the two values (your sum or 275). Thus
effectively creating a "maximum" total of 275.

HTH,
Elkar
 
Back
Top