I think that Chuck may have been alluding to the fact that with your figures
as salesman gets 800 commission for 10,000 but gets LESS than that for all
values up to 13,333! Similarly he gets 1,200 commission for 20,000 but
needs to to more than 30,000 before he will get that much again.

From the information you gave it is not clear what you want for exactly
10,000. I am going to assume that you meant <=10,000 adjust the formula if
not:

=A1*(4-(A110000)-(A120000))*0.02


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


" wrote in
message ...
it is. Any help ?

"CLR" wrote:

I sure hope that's not a Sales Commssion scale..........

Vaya con Dios,
Chuck, CABGx3



" wrote:

I need the formula to multiply by 3 diferent rates base on the
following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04.
can
anyone help ?