Peter Muller
Board Regular
- Joined
- Oct 15, 2018
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
Good afternoon,
I please need assistance with the following, VBA probably the solution.
Each employee is rated once every 3 months, and scores between 0 and 100%, with the applicable rating score transferred to their appraisal.
Can you please assist me with the code to determine the rating. It is a manual process at the moment for the 120+ employees.
I please need assistance with the following, VBA probably the solution.
Each employee is rated once every 3 months, and scores between 0 and 100%, with the applicable rating score transferred to their appraisal.
Can you please assist me with the code to determine the rating. It is a manual process at the moment for the 120+ employees.
TABLE | |
SCORE | RATING |
80 - 100% | 7 |
70 - 79% | 6 |
60 - 69% | 5 |
50 - 59% | 4 |
40 - 49% | 3 |
30 - 39% | 2 |
0 - 29% | 1 |