Healthcare & Clinical
Braden Scale in a Spreadsheet: Six Subscores and Score Ranges
Learn how to sum the six Braden subscale scores and check complete, valid integer inputs using fictional examples.
Six subscales and a lower-is-higher-risk score
The Braden Scale has six subscales: sensory perception, moisture, activity, mobility, nutrition, and friction and shear. Each of the first five ranges from 1 to 4; friction and shear ranges from 1 to 3. The total is therefore 6–23, with a lower score generally indicating higher pressure-injury risk.
AHRQ describes 18 or less as a commonly used threshold, while noting that a threshold may be adjusted for the population or local guidelines. A score above that threshold does not mean no risk: assessment should also consider factors the scale does not capture.
| Commonly shown band | Total points |
|---|---|
| Very high | 6–9 |
| High | 10–12 |
| Moderate | 13–14 |
| At risk | 15–18 |
| Above common threshold | 19–23 |
Validate and sum six fictional scores
Enter one integer for every subscale. The formula rejects missing, text, fractional and out-of-range values, including a friction and shear score over 3.
This arithmetic illustration is not a complete risk assessment or a care plan; prevention must consider the person, the individual subscale findings and the relevant clinical protocol.
=IF(COUNT(B2:B7)<>6,"Enter all six numeric scores",IF(OR(MIN(B2:B6)<1,MAX(B2:B6)>4,B7<1,B7>3,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0),"Check the six integer scores",SUM(B2:B7)))Show a commonly used band
The band labels illustrate published cutoffs. Thresholds and preventive decisions are context-dependent and must not be determined from a single total alone.
=IF(COUNT(B2:B7)<>6,"Enter all six numeric scores",IF(OR(MIN(B2:B6)<1,MAX(B2:B6)>4,B7<1,B7>3,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0),"Check the six integer scores",IF(SUM(B2:B7)<=9,"Very high band",IF(SUM(B2:B7)<=12,"High band",IF(SUM(B2:B7)<=14,"Moderate band",IF(SUM(B2:B7)<=18,"At-risk band","Above common 18-point threshold"))))))Try the example
Use the original values or change them to test your understanding.