Assistance with multi-cell formula

[WashingtonDC]

I need to generate a calculated cell (high risk vs. low risk) based on the following criteria of 4 other cells:

1. Number of hospital readmission within 30 days of discharge in the past year : 1 readmission = 2 points
2. Number of ED visits in the last 6 months : 1 ED visit = 2 points
3. Number of hospitalizations in the last 6 months : 1 hospitalization = 3 points

The score needs to be added up and if it is greater then or equal to 7 risk = "high". This is all superseded by " Hospitalization in the last 30 days". If this cell equals "yes", regardless of score of the other 3 cells, then risk is "high"

 

[DRSteele]

I think this is what you're after. If you don't want the reference table, you can hard-code the values into the formula. Copy F8 downwards.

	A	B	C	D	E	F
1		Condition	Points
2		Re-admission_30days	2
3		ED visits_6months	2
4		Hospiltalisations_6months	3
5		Risk Hurdle	7
6
7	Patient	Re-admission_30days	ED visits_6months	Hospiltalisations_6months	Hospiltalisations_30days	RISK
8	Able	1	2	0	Yes	High
9	Baker	0	2	1	No	High
10	Charlie	1	1	0	No	Low
11	Dog	2	2	2	Yes	High
12	Easy	0	4	0	No	High
13	Fox	0	0	2	No	Low

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet56​

Worksheet Formulas Cell Formula F8 =IF(OR(E8="Yes",(B8*$C$2+C8*$C$3+D8*$C$4)>=$C$5),"High","Low") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>