Hello,

I am trying create a formula that will calculate commission. I would like a
single formula that will calculate $8.00 for the first 16 sales (sales 1 €“
16), $12.00 for the next five sales (sales 17 €“ 21) and $15.00 for each sale
at 22 or more.

So if I sold 23 units the commission will be $218.00.

The number of units sold will be in cell A1.

Thanks for the help.