Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Dermatology Life Quality Index: Ten-Item Score Arithmetic

Explore the arithmetic of ten fictional DLQI item scores, the official missing-response guidance, and the limitations of using a score alone.

Understanding the ten-item score

The Dermatology Life Quality Index (DLQI), developed by Finlay and Khan, asks about the effect of a skin condition on quality of life over the preceding week. Ten items are scored from 0 to 3, with a total from 0 to 30. Published interpretation bands describe increasing impact, but a total cannot capture every aspect of a person’s experience.

A DLQI above 10 does not by itself establish eligibility for a biological treatment. For example, NICE guidance for particular psoriasis medicines includes additional severity, treatment-history and individual circumstances. Decisions depend on the complete assessment and the relevant guidance.

Total scorePublished impact description
0–1No effect on quality of life
2–5Small effect
6–10Moderate effect
11–20Very large effect
21–30Extremely large effect

Add ten complete, already-scored values

This teaching example accepts ten fictional, pre-scored integers from 0 to 3 and returns their sum. It is an arithmetic exercise, not a questionnaire or treatment-eligibility tool.

Cardiff University’s official instructions allow one unanswered question to be scored as zero; with two or more unanswered, the questionnaire is not scored. This complete-response example instead requires all ten numeric entries and does not implement the official missing-data rule. Consult Cardiff’s full instructions when administering or interpreting the instrument.

=IF(COUNT(B2:B11)<>10,"Enter all ten numeric scores for this example",IF(OR(MIN(B2:B11)<0,MAX(B2:B11)>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,MOD(B8,1)<>0,MOD(B9,1)<>0,MOD(B10,1)<>0,MOD(B11,1)<>0),"Each score must be an integer from 0 to 3",SUM(B2:B11)))

Try the example

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

Further reading