Running Total Maximum?
 

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.

Running Total Maximum?
 

Please ignore. I figured out why my equation wasn't working.

On Mon, 07 Aug 2006 09:48:49 -0700, Mr. X wrote:

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(S heetName!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.

Running Total Maximum?
 

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


"Mr. X" wrote:

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.