Hi All,
I am working on dashboard in which target based scores are being given.
e.g Min & Max target for Calling - Minimum 60 call and Max >=70 calls per day Minimum score 0 and Maximum is 20%, Score will be proportionate where Achievement 61= Score will be 2% , Achv 62= Score 4% and so on....
I think i should use Min Max formula to handle this type of calculations, can you please help me designing formulas for below criteria
Input values in A Column and score will be in B column
<colgroup><col span="4" style="text-align: center;"></colgroup><tbody>
</tbody>
Sanket
I am working on dashboard in which target based scores are being given.
e.g Min & Max target for Calling - Minimum 60 call and Max >=70 calls per day Minimum score 0 and Maximum is 20%, Score will be proportionate where Achievement 61= Score will be 2% , Achv 62= Score 4% and so on....
I think i should use Min Max formula to handle this type of calculations, can you please help me designing formulas for below criteria
Input values in A Column and score will be in B column
Input | Score | ||
Min | Max | Min | Max |
60 | >=70 | 0% | 20% |
30 sec | >=60 sec | 0% | 10% |
85.0% | >=95% | 0% | 10% |
30% | >=50% | 0% | 15% |
80% | >=90% | 0% | 15% |
95% | >=100% | 0% | 15% |
50 min | >=60 min | 0% | 30% |
95.0% | >=100% | 0% | 20% |
0.02 | >=0.01 | 0% | 50% |
80% | >=90% | 0% | 30% |
80% | >=90% | 0% | 20% |
0.95 | >=1 | 0% | 20% |
0.02 | >=0.01 | 0% | 50% |
180 min | >=120 min | 0% | 50% |
95% | >=100% | 0% | 30% |
40min | >=30min | 0% | 30% |
0.95 | >=1 | 0% | 20% |
0.85 | >=0.9 | 0% | 50% |
85% | >=90% | 0% | 50% |
<colgroup><col span="4" style="text-align: center;"></colgroup><tbody>
</tbody>
Sanket