View Single Post
  #6   Report Post  
Blue Hornet
 
Posts: n/a
Default

It's still not clear enough exactly what you're trying to achieve. If
you're paying an incentive based on three components, but you don't
want the incentive payment to be $400, then you can do it the way I
suggest:
= MIN(( A + B + C) * 5, 400)
and you don't have to change any of the individual components. What
would be the point? It seems to me that the point is to arrive at "the
incentive payment", not "the components of the incentive".

If you're trying to get somewhere else, it's not clear from your
posting where that would be. If your components a
Appearance, Promptness and Accuracy, for example, you always want to
maximize those, right? You don't want to rank one of them back to 0
just because a max incentive "payment" has been achieved. Sort of
defeats the purpose of the incentive, no?

Anyway, it's all just idle speculation on my part until I really
understand where you're going.