Hi!

Here's another method.

Assume sale amount is in A1.

=A1*LOOKUP(A1,{0,0.2;2000.01,0.4})

You use the lower boundary of each commission range. In the above formula
any amount over 2000.01 will recieve a 40% commission. If you have another
range, say, 4000.01 and greater @ 45%:

=A1*LOOKUP(A1,{0,0.2;2001,0.4;4000.01,0.45})

Just add ranges as needed.

Biff

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