Using IF functions complete each of the green fields for each of the different problems

Save of the gr 42 43 44 Problem #5 Sales people get a sales bonus based on units sold according to the schedule 45 Bonus criteria 46 Low Point High Point Bonus -Using IF 47 0 749 0% 48 750 1499 1% 49 1500 2249 2% 50 2250 and higher 3% different 51 use IF sta 52 Sales Person Unit Sales Monthly Sales Sales Bonus 53 Sally Blue 1,500 8,450.00 compute 54 Mary Magenta 2200 9,500.00 55 Betty White 2.100 11,250,00 -For each 56 Henry Green 2,500 13,500.00 57 Barry Black 1,500 7025.00 input bla 58 Scarlet Purple 1.750 9,580.00 used in t. 59 William Orange 1,800 10,250.00 60 just type 61 62 statemer