Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Lawton–Brody IADL: Functional Assessment and a Counting Example

Learn the purpose and limitations of the Lawton–Brody IADL scale and practice a separate eight-value spreadsheet count.

Understanding instrumental daily activities

Lawton and Brody described an assessment of daily activities in older people in 1969. Instrumental activities are tasks such as shopping, preparing food, transportation and managing medications or finances; they are distinct from basic self-care activities. The instrument is intended to support an assessment of function, not to diagnose dementia on its own.

The instrument’s domain responses are more nuanced than a simple declaration of full independence: some forms award a point in certain situations where a person uses limited assistance. The historical version also used different totals for men and women based on social roles at the time. Modern uses and adaptations vary, so the version and scoring instructions must be specified and considered in context.

A total alone cannot establish someone’s cognitive diagnosis, decision-making capacity, ability to live safely or need for supervised housing. Functional assessment should consider the person’s goals, environment, cultural context, support and health, with an appropriate professional assessment where needed. The linked sources describe the original instrument and its limitations.

A separate binary-counting exercise

For a generic spreadsheet exercise, enter eight example values of 0 or 1 in B2:B9. COUNT requires eight numeric entries; the remaining checks reject fractional and out-of-range values. This exercise is not the Lawton–Brody assessment and does not classify a person or recommend care.

=IF(COUNT(B2:B9)<>8,"Enter all eight numeric values",IF(OR(MIN(B2:B9)<0,MAX(B2:B9)>1,INT(B2)<>B2,INT(B3)<>B3,INT(B4)<>B4,INT(B5)<>B5,INT(B6)<>B6,INT(B7)<>B7,INT(B8)<>B8,INT(B9)<>B9),"Values must be 0 or 1",SUM(B2:B9)))

Try the example

Use the original values or change them to test your understanding.

Further reading