Howdy All,

I'm trying to write a formula that will look at a cell (say A1), which is a
profit margin in percent (ie: 25%), then based on the range the margin falls
in, place a Commission rate in the cell.

Example.

A1 = 25%

Commission Ranges by Profit Margin:

0 to 18% = 0% commission
18% to 25% = 22% commission
25% = 30% commission.

So what I want is a formula that will look at the profit margin in A1 and
put the appropriate commission rate in the cell.

Thanks a million!
Brian