Hi JE,

That's all fine...it can add up to 400, it's when any one of A1 or B1 or C1
get to 400, then I want the other two cells to go to 0.

In other words, since there is a cap of 400, any one of the 3 cells can't
show over 400. I know how yo do a MAX function, but that isn't helping me
with this. I need 2 cells to be 0 if one has reached 400.

Thanks, CP

"JE McGimpsey" wrote:

Your question appears to me to be ambiguous as stated.

If any combo can reach a cap of 400, what happens in the case that, say:

A1: 100
B1: 200
C1: 100

and A1 increases to 150. How should B1 and C1 be adjusted?



In article ,
"CP" wrote:

Hi,

I want to calculate results of an incentive that has 3 components all of
which are 'x' times $5 to calculate their total bonus.

Any combo of the 3 can reach a cap of $400. My question is when one of the
3 cells reaches the cap of $400, how do I get the other 2 to default to 0
without there being a circular reference?

Thanks