Thanks for tip on the website it was very helpfull to me.
Harvey



"Niek Otten" wrote in message
...
Hi Harvey,

Look here for a generic solution:

http://www.mcgimpsey.com/excel/variablerate.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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
|
|