Assistance with multi-cell formula

WashingtonDC

New Member
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"

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

DRSteele

Well-known Member
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.

ABCDEF
1ConditionPoints
3ED visits_6months2
4Hospiltalisations_6months3
5Risk Hurdle7
6
8Able120YesHigh
9Baker021NoHigh
10Charlie110NoLow
11Dog222YesHigh
12Easy040NoHigh
13Fox002NoLow

</tbody>
Sheet56

Worksheet Formulas
CellFormula
F8=IF(OR(E8="Yes",(B8*\$C\$2+C8*\$C\$3+D8*\$C\$4)>=\$C\$5),"High","Low")

</tbody>

<tbody>
</tbody>

Replies
0
Views
103
Replies
1
Views
128
Replies
10
Views
244
Replies
6
Views
309
Replies
11
Views
65

1,191,213
Messages
5,985,300
Members
439,956
Latest member
FrazzledCat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back