Healthcare & Clinical Formulas
Hendrich II: Educational Weighted Score Example
Practice the arithmetic of the Hendrich II weighted score using already-assessed example inputs, with missing-value checks and current guideline context.
Weighted arithmetic in a published model
The Hendrich II model combines seven assessed factors with a chair-rise component. The published weights for the seven factors are 4, 2, 1, 1, 1, 2 and 1; the chair-rise component can contribute 0, 1, 3 or 4 points. This workbook starts with already-assessed inputs and demonstrates the arithmetic only.
For the chair-rise component, zero corresponds to rising in a single movement; one corresponds to pushing up and succeeding in one attempt; three to multiple attempts before success; and four to inability to rise without assistance. If an assessment cannot be performed, do not assume a zero. The formula requires a recorded numerical input rather than deciding whether a test is safe to perform.
The model commonly uses a total of 5 or more as its high-risk threshold, but a numerical score does not determine individual risk or which intervention to use. NICE guideline NG249 (2025), covering people 65 and older and people 50–64 with a factor increasing risk, recommends not using falls risk prediction tools to predict an individual’s falls risk. Apply the relevant clinical guidance and individualized assessment rather than this teaching worksheet.
| Input | Allowed value in this example | Contribution |
|---|---|---|
| Seven assessed factors | Each 0 or 1 | 4, 2, 1, 1, 1, 2, 1 respectively |
| Chair-rise component | 0, 1, 3 or 4 | Entered value |
| All eight components | Complete numeric inputs | Total 0–16 |
Calculate the weighted total
Enter the seven assessed flags as numeric 0/1 and the separately assessed chair-rise points as 0, 1, 3 or 4. Missing values and text are not treated as zero.
=IF(COUNT(B2:B9)<>8,"Missing or nonnumeric input",IF(OR(AND(B2<>0,B2<>1),AND(B3<>0,B3<>1),AND(B4<>0,B4<>1),AND(B5<>0,B5<>1),AND(B6<>0,B6<>1),AND(B7<>0,B7<>1),AND(B8<>0,B8<>1),AND(B9<>0,B9<>1,B9<>3,B9<>4)),"Invalid flag or chair-rise score",4*B2+2*B3+B4+B5+B6+2*B7+B8+B9))Compare with the published numerical cutoff
This labels the score range only; it does not predict a fall or prescribe a prevention bundle.
=IF(COUNT(B2:B9)<>8,"Missing or nonnumeric input",IF(OR(AND(B2<>0,B2<>1),AND(B3<>0,B3<>1),AND(B4<>0,B4<>1),AND(B5<>0,B5<>1),AND(B6<>0,B6<>1),AND(B7<>0,B7<>1),AND(B8<>0,B8<>1),AND(B9<>0,B9<>1,B9<>3,B9<>4)),"Invalid flag or chair-rise score",IF((4*B2+2*B3+B4+B5+B6+2*B7+B8+B9)>=5,"At least 5 points","Below 5 points")))Try the example
Use the original values or change them to test your understanding.