.. I know it's simple ..
And it may not be as simple as it seems ..

Try JE's page at:
http://www.mcgimpsey.com/excel/variablerate.html
which shows the way to handle it
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"kalsolelady" wrote in message
...
I need to set up a spreadsheet in Excel 2003 to calculate comission of
sales
on a graduated scale. Salesman sells $0-2000, he receives 20% commission;
$2000.01-4000, 40%; etc. I know it's simple, but I'm stuck. Any help is
appreciated. Thank you.