[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Criteria
[/TD]
[TD]Range
[/TD]
[TD]Score
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$500,000.00 and $999,999,999.99
[/TD]
[TD]89
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$100,000.00 and $499,999.99
[/TD]
[TD]79
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$50,000.00 and $99,999.99
[/TD]
[TD]69
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$25,000.00 and $49,999.99
[/TD]
[TD]59
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]121 - 180
[/TD]
[TD]68
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]181 - 300
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]301 - 360
[/TD]
[TD]78
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]361 - 9999
[/TD]
[TD]38
[/TD]
[/TR]
[TR]
[TD] Denial Date
[/TD]
[TD]30 to 60
[/TD]
[TD]26
[/TD]
[/TR]
[TR]
[TD] Denial Date
[/TD]
[TD]61 and 9999
[/TD]
[TD]36
[/TD]
[/TR]
[TR]
[TD]Last User Work Date
[/TD]
[TD]45 and 9999
[/TD]
[TD]47
[/TD]
[/TR]
</tbody>[/TABLE]
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.
<tbody>[TR]
[TD]Criteria
[/TD]
[TD]Range
[/TD]
[TD]Score
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$500,000.00 and $999,999,999.99
[/TD]
[TD]89
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$100,000.00 and $499,999.99
[/TD]
[TD]79
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$50,000.00 and $99,999.99
[/TD]
[TD]69
[/TD]
[/TR]
[TR]
[TD]Account Balance
[/TD]
[TD]$25,000.00 and $49,999.99
[/TD]
[TD]59
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]121 - 180
[/TD]
[TD]68
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]181 - 300
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]301 - 360
[/TD]
[TD]78
[/TD]
[/TR]
[TR]
[TD]Discharge Date
[/TD]
[TD]361 - 9999
[/TD]
[TD]38
[/TD]
[/TR]
[TR]
[TD] Denial Date
[/TD]
[TD]30 to 60
[/TD]
[TD]26
[/TD]
[/TR]
[TR]
[TD] Denial Date
[/TD]
[TD]61 and 9999
[/TD]
[TD]36
[/TD]
[/TR]
[TR]
[TD]Last User Work Date
[/TD]
[TD]45 and 9999
[/TD]
[TD]47
[/TD]
[/TR]
</tbody>[/TABLE]
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.