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.
| Item | Topic |
|---|---|
| 1 | Frequency of drinking |
| 2 | Typical number of drinks on a drinking day |
| 3 | Frequency 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.