IF THEn Formula
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 ?
|