Take a look here

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

--
Regards,

Peo Sjoblom

(No private emails please)


"FloridaMaggie" wrote in message
...
I'm trying to create a spreadsheet for commission purposes.

Different commission percentages are paid based on a range of sales.

For example:

Sales between $80,000 to $100,000 earns 10% commission
Sales between $50,000 to $79,000 earns 8% commission, etc.

Does an array formula work for this? I've been trying to create one with
no
luck

I appreciate any help