Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

AUDIT-C Alcohol Screening: Scoring and Input Checks

Learn what AUDIT-C screens for and practice summing three pre-scored responses without treating missing or inconsistent entries as abstinence.

What AUDIT-C does

AUDIT-C is a three-question screening instrument about alcohol consumption, using scored responses from 0 to 4 for a total from 0 to 12. It is a screening tool rather than a diagnosis of alcohol use disorder. A positive screen calls for appropriate follow-up and a fuller assessment.

Different populations and settings use different thresholds. For example, some guidance uses 4 or more for men and 3 or more for women; other protocols use different thresholds. An isolated score, including 8 or more, does not by itself establish dependence severity. Use the version and guidance appropriate to the setting.

ItemTopic
1Frequency of drinking
2Typical number of drinks on a drinking day
3Frequency of heavy episodic drinking

Sum three fictional pre-scored answers

Enter three integer scores from 0 to 4. This teaching example requires an explicit score for each item; if an official questionnaire uses a skip rule, record the skipped items according to that instrument’s instructions before entering a score. Missing answers are not silently converted to zero.

If the first score is 0 but either later score is nonzero, the formula flags the combination for review instead of discarding the later responses. It returns an arithmetic total only, not an assessment of individual risk or a treatment recommendation.

=IF(COUNT(B3:B5)<>3,"Enter all three numeric item scores",IF(OR(MIN(B3:B5)<0,MAX(B3:B5)>4,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0),"Each item must be an integer from 0 to 4",IF(AND(B3=0,OR(B4<>0,B5<>0)),"Inconsistent responses: review entries",SUM(B3:B5))))

Try the example

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

Further reading