Need help with =IF formula
Maybe something like this:
=IF(A1<100,A1*0.15,IF(A1<200,(100*0.15)+((A1-100)*0.1),(100*0.15)+(100*0.1)+((A1-200)*0.05)))
HTH,
Paul
"Harvey" wrote in message
...
I need a formula to do this: if the sale is less than $100 the commission
is 15% of the sale, if the sale is less then $200 the commission is 15% on
the first hundred + 10% of the balance of the sale, and if the sale is over
$200 the commission is 15% of the first $100 , 10% of the second $100 and
5% for anything over $200.
I came up with =IF(D9<100,".15",IF(D9<200,".1","")) which does not come
near to what I need.
I need help, I am using Excel 2002.
Harvey Mandel
|