Formula(s) needed for Tiered Commission structure

https://www.excelcampus.com/modeling...ate-structure/
plz refer above link.

Ok I have done the steps but I am stuck at the point where you enter in the Sales person budget and actual figures
and it gives you a $ value to pay. its like the last 2 steps are missing for this work sheet