= 50 the employee gets 100.00 * no of customers• f the total number of customers >= 25 they get 50.00 * no of customersIf the number of customers was any less, show "No Bonus"Here's what the...

= 50 get 100.00 per customer Orion Sharp Monty Hahn Sidra Emery Josef Hensley Katie Rowley Amani Almond Avaya Downs 23 1150 If no cusomers is 50-25 get 50.00 per customer If no customers is less "no bonus" 41 4100 18 900 High Threshold Med Threshold Top Bonus 7 No Bonus 35 51 5100 18 100.00 50.00 No Bonus 22 1100 19 950 Med Bonus Katelin Felix 37 3700 Low Bonus Antoinette Stout 34 1700 Lower the thresholds and the bonus percentage rates to check that your formula works. Save this as firstname_lastname_conditional_formulae "/>
Extracted text: ACTIVITY # 3 Create a nested =IF formula to calculate the employee bonus for each employee member. Use this to help you: • If the total number of customers >= 50 the employee gets 100.00 * no of customers • f the total number of customers >= 25 they get 50.00 * no of customers If the number of customers was any less, show "No Bonus" Here's what the resulting worksheet should look like: ΕMPLOYEE ΝΑΜΕ TOTAL CUSTOMER BONUS Tom Burnett 15 No Bonus If no customers >= 50 get 100.00 per customer Orion Sharp Monty Hahn Sidra Emery Josef Hensley Katie Rowley Amani Almond Avaya Downs 23 1150 If no cusomers is 50-25 get 50.00 per customer If no customers is less "no bonus" 41 4100 18 900 High Threshold Med Threshold Top Bonus 7 No Bonus 35 51 5100 18 100.00 50.00 No Bonus 22 1100 19 950 Med Bonus Katelin Felix 37 3700 Low Bonus Antoinette Stout 34 1700 Lower the thresholds and the bonus percentage rates to check that your formula works. Save this as firstname_lastname_conditional_formulae