HI team I am working on a sales excel workbook that will help with trends, forcasting, comissions, daily targets etc. Stumbling through and I need some assistance with the below scenario and how to enter:

I have attached the workbook I have made from scratch.

Here is the formula I need help with:

if sales $0-$20,000 no commission,
if sales $20,000-$45,000 7.5% commission on all sales.
if sales >$45,000 - Budget 10% commission on all sales.
if sales >$45,000 + > combined budget 15% commission on all sales.

Local Market tab Cell C136-N136 are the cells that need to calculate and reference back to the landing page tab.

Happy to take advice on board and thanks in advance for any help or point me into a direction of where to learn and do what I need done.