With total sales in A1 and percentage of sales in B1, enter this formula in C1

=LOOKUP(B1,{0,50,61,71,81,91},{0,0.25,0.5,0.75,1,1 .25})*A1


Gord Dibben MS Excel MVP

On Wed, 21 May 2008 11:10:00 -0700, Mattymoo
wrote:

I'm trying to develop a formula to calculate a sales team incentive bonus. A
bonus amount is calculated based on sales made, but then is adjusted 3 months
later based on the criteria below.


Less than 50% of sales still on the books 0% payable
50% to 60% of sales 25%
61% to 70% of sales 50%
71% to 80% of sales 75%
81% to 90% of sales 100%
Over 90% of sales 125%

I'm afraid I don't know where to start - can anyone point me in the right
direction?

Thanks