Using IF functions compute sales bonus for each different scenarios

20 William Orange 10,250.00 21 Sales people get a 3% bonus (monthly sales * 03), if they sold over $10,000 in the 22 Problem #3 month AND brought in 3 or more new customers 23 Sales Person Unit Sales Monthly Sales New Customers Sales Bonus 24 Sally Blue 1,500 8,450,00 3 25 Mary Magenta 2200 9,500.00 2 26 Betty White 2,100 11250,00 1 27 Henry Green 2.500 13,500.00 3 28 Barry Black 1,500 7025.00 1 29 Scarlet Purple 1,750 9,580.00 4 30 William Orange 1,800 10250,00 31 32 Sales people get a 3% bonus (monthly sales 03), if they (sold over 2,000 units 33 Problem #4 and have sales over $10,000) or brought in 3 or more new customers 34 Sales Person Unit Sales Monthly Sales New Customers Sales Bonus 35 Sally Blue 1,500 8.450.00 3 36 Mary Magenta 2,200 9,500.00 2 37 Betty White 2100 11 250.00 1 38 Henry Green 2,500 13,500.00 39 Barry Black 1,500 7 025.00 40 Scarlet Purple 1,750 9,580.00 41 William Orange 1.800 10,250.00