ACTIVITY # 3 Create a nested =IF formula to calculate the employee bonus for each employee member. Use this to help you: • fi the total number of customers >= 50 the employee gets 100.00 * no of customers • fi 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: EMPLOYEE NAME TOTAL CUSTOMER BONUS Tom Burnett Orion Sharp Monty Hahn Sidra Emery Josef Hensley Katie Rowley Amani Almond 15 No Bonus 1150 4100 900 If no customers > 50 get 100.00 per customer 23 If no cusomers is 50-25 get 50.00 per customer 41 If no customers is less "no bonus" 18 7 No Bonus 5100 High Threshold Med Threshold Top Bonus 35 51 22 18 1100 100.00 50.00 No Bonus Avaya Downs 950 3700 19 Med Bonus 37 34 Katelin Felix Low Bonus Antoinette Stout 1700 Lower the thresholds and the bonus percentage rates to check that your formula works. Save this as firstname_lastname_conditional_formulae
ACTIVITY # 3 Create a nested =IF formula to calculate the employee bonus for each employee member. Use this to help you: • fi the total number of customers >= 50 the employee gets 100.00 * no of customers • fi 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: EMPLOYEE NAME TOTAL CUSTOMER BONUS Tom Burnett Orion Sharp Monty Hahn Sidra Emery Josef Hensley Katie Rowley Amani Almond 15 No Bonus 1150 4100 900 If no customers > 50 get 100.00 per customer 23 If no cusomers is 50-25 get 50.00 per customer 41 If no customers is less "no bonus" 18 7 No Bonus 5100 High Threshold Med Threshold Top Bonus 35 51 22 18 1100 100.00 50.00 No Bonus Avaya Downs 950 3700 19 Med Bonus 37 34 Katelin Felix Low Bonus Antoinette Stout 1700 Lower the thresholds and the bonus percentage rates to check that your formula works. Save this as firstname_lastname_conditional_formulae
C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter5: Control Structures Ii (repetition)
Section: Chapter Questions
Problem 20PE: When you borrow money to buy a house, a car, or for some other purpose, you repay the loan by making...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Recommended textbooks for you
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning