Criteria | Range | Score |
Account Balance | $500,000.00 and $999,999,999.99 | 89 |
Account Balance | $100,000.00 and $499,999.99 | 79 |
Account Balance | $50,000.00 and $99,999.99 | 69 |
Account Balance | $25,000.00 and $49,999.99 | 59 |
Discharge Date | 121 - 180 | 68 |
Discharge Date | 181 - 300 | 48 |
Discharge Date | 301 - 360 | 78 |
Discharge Date | 361 - 9999 | 38 |
Denial Date | 30 to 60 | 26 |
Denial Date | 61 and 9999 | 36 |
Last User Work Date | 45 and 9999 | 47 |
<tbody>
</tbody>
Hi Excel Gurus!
Can someone please help me with a formula or set of formulas to calculate the scoring possibilities of the following criteria? There are 4 categories with specific values. From all the scoring possibilities, I will calculate the potential H/M/L ranges.