Question
Next, you need to begin determining the employees final raise. Add the following. In cells H6:H13, add an IF function that will award anyone with
Next, you need to begin determining the employees final raise. Add the following. In cells H6:H13, add an IF function that will award anyone with a Raise Recommend of High an extra bonus listed in cell F2. All other employees get zero bonus. In cells I6:I13, add an IF function that will give anyone with a Raise Recommend of Low a deduction listed in cell F3. All other employees get zero deduction.
On the Payroll worksheet, in cells J6:J13, add a calculation that returns the final raise amount with the valuenot just formattedrounded to the hundreds position (-2). For example, a final raise of $1,625 rounded to the hundreds returns a value of $1,600. The final raise amount is the salary multiplied by the Standard Raise % and then adding any bonus and subtracting any deduction.
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