Hi sir/madam

Hi need urgent help for excel formula. I have data from cell A2 to A11 and I want that top 35% will get $4000.00. and next 35% will get $2000.00. and rest 30% will get $5000.00 in cell B2 to B11.

Please help me urgent

Kind regards
Vinod