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
