J
jeffmp21
I'm using Excel 2000 and have the following problem:
Column A has an employee's performance rating 10,20,30,40, or 50
Column B has the employee's current salary
Column C will calculate the employees increase 0, .5,
1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0
Column D has a min wage range
Column E has a middle wage range
Column F has the max wage
Columns B, D,E, and F are prepopulated.
Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid=
43,043, Max = 55,097
Would receive a 2.5% raise
Based on:
Meeting expections (30 rating) but is in the upper third of the range
Column A has an employee's performance rating 10,20,30,40, or 50
Column B has the employee's current salary
Column C will calculate the employees increase 0, .5,
1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0
Column D has a min wage range
Column E has a middle wage range
Column F has the max wage
Columns B, D,E, and F are prepopulated.
Example employee has a 30 rating, makes $51,974, the min is 30,746, Mid=
43,043, Max = 55,097
Would receive a 2.5% raise
Based on:
Meeting expections (30 rating) but is in the upper third of the range