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
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7dc30860-6c2e-425e-a209-34431047979f%2F35c8e450-4797-4fd4-86fa-b7b1f5d8f20d%2Faxzjyyx_processed.png&w=3840&q=75)
Transcribed Image 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
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![C++ Programming: From Problem Analysis to Program…](https://www.bartleby.com/isbn_cover_images/9781337102087/9781337102087_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9781337102087/9781337102087_smallCoverImage.gif)
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning