Arte SheetsLearn. Try. Understand.

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 bandTotal points
Very high6–9
High10–12
Moderate13–14
At risk15–18
Above common threshold19–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.

Further reading