I'm creating an employee performance database and need to know how to assign a score dependent on a percentage.
For instance, if an employee achieves between 99.8% and 100%, the score should be "5". If the employee achieves between 99.5% and 99.79%, the score should be "4" - and so forth. The formula would need to look at the one percentage and determine which score to give (between 1 & 5).
Can anyone assist me with this?
For instance, if an employee achieves between 99.8% and 100%, the score should be "5". If the employee achieves between 99.5% and 99.79%, the score should be "4" - and so forth. The formula would need to look at the one percentage and determine which score to give (between 1 & 5).
Can anyone assist me with this?