5% Created Nested If/And Formulas 1. Calculate the commission amount of salespersons with sales of $50K or more and earned customer "A" rating Sales Customer Rating Commission Note: Show N/A for those not receiving 1 Quarterly Sales Commissions 2 3 Greater Than or Equal to $50,000 4 A Customer Rating 5 6 Salesperson 7 8 Anna Simons 9 John Smith 10 Frank Brown 11 Susie Jones 12 Harry Bronson 13 Thelma Stevens 14 Bob Flpatrick 15 Total 16 commission 2. Bold and shade commission amounts $ $ $ $ $ $ $ $ 50,000 49,000 70,000 65,000 45,000 100,000 25,000 404,000 A A A