Excel formula help please

Hello Everyone,   I need your support on something. I want to create a bonus table and tell the customer representative how much bonus he should receive. The table is as follows. Column (A) Custome...