Hi,
I need help creating a formula for the following scenario. I need to assign a gradual decreasing score by 1 starting at 25 for any Make busy %age attained >12%. So for Agents with > 12%MKB,first ranked gets 25 points and there on 1 point deducted for each lower rank. Decrease by 1 point until 0 points is reached. See Example below.
MKB% Score
13 25
14 24
15 23
16 22
17 21
18 20
19 19
20 18
21 17
22 16
23 15
Thanks for the help.
Bookmarks