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(Sh eetName!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.