Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If the Dept is 6007, enter 900, if the Department is 4305, enter 600, if the Department is 4312, enter 350, otherwise enter 200. Copy
If the Dept is 6007, enter 900, if the Department is 4305, enter 600, if the Department is 4312, enter 350, otherwise enter 200. Copy the function down for the employees. Calculate the total Department Bonus for all the employees in cell P1. What is this amount? Format as comma style, 0 decimals
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started