Another way of putting this is $8/unit, PLUS $4/unit for all units over 16,
PLUS $3/unit for all units over 21:
=8*A1 + 4*max(0,A1-16) + 3*max(0,A1-21)

"JR" wrote:

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.