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.