I am looking for help with an If statement for Excel. I am trying to
build a commission calculator with a tiered payout schedule. This is
what the tiers will look like;

2% paid on all sales between $30000 and $70000
3% paid on all sales between $70000 and $120000
4.5% paid on all sales between $120000 and $150000
5.5% paid on all sales above $150000

Total sales will be found in cell C16

example
$100000 in sales would net;
2% paid on $40000 (sales between 30 and 70K)
+ 3% paid on $30000 (sales between 70 and 100K)

Any assistance would be greatly appreciated. Thank you in advance.

Anthony