Arte SheetsLearn. Try. Understand.

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.

InputAllowed value in this exampleContribution
Seven assessed factorsEach 0 or 14, 2, 1, 1, 1, 2, 1 respectively
Chair-rise component0, 1, 3 or 4Entered value
All eight componentsComplete numeric inputsTotal 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.

Further reading