Hi to all good people,

I am looking for formula help that can save my life,
My question is

Target Achieved Percentage Payout

100cases =30% Nil
30-40% 15Per case
40-50% 25Per case
50-60% 40Per case
<=60% 50Per cas
If a sales person Achieves =30% he is not gentting any commission but
salary only. When he is doing 30%+ he is getting commission from very first
case ie. Target is 200 and Achieved cases are 70 means 35% he gets 15 per
cases Amount is 70*15 = 1050.

I hope it is enough to make u understand my problem and also hopeful will
get the answer from community's good people,I am thanking you all in advance

Aarif