Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

FeverPAIN Score: Five Criteria in a Spreadsheet

Explore FeverPAIN arithmetic using fictional sore-throat criteria, with input checks and the context needed to understand UK NICE guidance.

Five criteria and the scope of the evidence

FeverPAIN assigns one point each for fever during the previous 24 hours, tonsillar purulence, attendance within three days of symptom onset, severely inflamed tonsils, and no cough or coryza. The total is 0–5. The original PRISM cohorts studied acute sore throat and isolation of streptococci; a score is not a definitive test result.

NICE guidance uses FeverPAIN as one aid to antibiotic decisions, alongside clinical assessment. Its recommendations separately address people who are systemically very unwell, have signs of a more serious illness, or are at high risk of complications. The score alone must not overrule those considerations, and recommendations may differ outside the UK.

CriterionPoint when present
Fever in previous 24 hours1
Purulent tonsils1
Attendance within three days1
Severely inflamed tonsils1
No cough or coryza1

Sum fictional criteria with complete input validation

Use 0 or 1 for each of the four flags and a nonnegative duration in days. Duration of exactly three days receives the attendance point; 3.01 days does not. The spreadsheet requires all five numeric inputs and rejects nonbinary flags.

This example returns the numeric total only. NICE’s management options depend on the complete clinical situation; the formula does not diagnose strep throat or prescribe or withhold antibiotics.

=IF(COUNT(B2:B6)<>5,"Enter all five numeric inputs",IF(OR(AND(B2<>0,B2<>1),AND(B3<>0,B3<>1),B4<0,AND(B5<>0,B5<>1),AND(B6<>0,B6<>1)),"Check the four flags and symptom duration",B2+B3+IF(B4<=3,1,0)+B5+B6))

Try the example

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

Further reading