Hmmmm...........typeo here's correction........

=IF(A120000,10000*0.08+10000*0.06+0.04*(A1-20000),IF(A110000,10000*0.08+0.
06*(A1-10000),0.08*A1))

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote in message
...
You may wish to consider something like this..........



=IF(A120000,10000*0.08+10000*0.06+0.08*(A1-20000),IF(A110000,10000*0.08+0.
06*(A1-10000),0.08*A1))

This way, the more the person sells, the more money they make.

Vaya con Dios,
Chuck, CABGx3




" wrote:

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 ?