Running Total Maximum?

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.
 
E

Elkar

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
 
Top