Hi team,
I have a score range which i want to change in reducing pattern instead of range. The highest weigtage is 3. If any of the employee gets No issue then they get full score 3 then for any number of instances recorded against their name the score should be reduced accordingly in decimals like 2.9, 2.8 etc., for increasing trend i use this formula =IF(D4>125%, 35, (D4/125%)*35 here 35 being highest score. but not sure how it works for reducing pattern.
I have a score range which i want to change in reducing pattern instead of range. The highest weigtage is 3. If any of the employee gets No issue then they get full score 3 then for any number of instances recorded against their name the score should be reduced accordingly in decimals like 2.9, 2.8 etc., for increasing trend i use this formula =IF(D4>125%, 35, (D4/125%)*35 here 35 being highest score. but not sure how it works for reducing pattern.
| Weight age | 3 |
| Mytime | Score |
| 0 | 3 |
| 1 to 5 | 2 |
| 5 to 10 | 1 |
| >10 | 0 |