Healthcare & Clinical
Ottawa Ankle and Foot Rules: Two Sets of Clinical Findings
Explore the ankle and midfoot rule combinations using explicitly assessed inputs, while recognizing the limits of an educational spreadsheet.
Two anatomical regions, two rule combinations
The Ottawa ankle and foot rules were developed to help clinicians consider radiography after acute ankle and midfoot injury. The ankle combination considers pain in the malleolar zone with bony tenderness at specified posterior or tip locations, or inability to bear weight. The foot combination considers midfoot pain with tenderness at the navicular or base of the fifth metatarsal, or the same weight-bearing finding.
In this example the shared B4 flag means inability to take four steps both immediately after injury and at assessment, as assessed by a clinician; a limp can still count as walking. Pain and tenderness refer to the specific sites and conditions of the rule, not any ache in the region.
The original adult validation does not guarantee a fracture-free result for an individual, and research has found differing performance in children. Impaired sensation, unreliable examination or other concerns can affect applicability. A negative combination is not a diagnosis and does not by itself determine whether imaging or follow-up is needed.
Wording of weight-bearing criteria differs across guidance: the American College of Radiology describes inability at either the injury or evaluation time as separate indications in its ankle-imaging guidance. This educational example uses the two-time formulation above; clinicians should follow the applicable local protocol.
Ankle-zone combination
For illustration, enter binary pre-assessed flags for malleolar-zone pain (B2), specified malleolar bony tenderness (B3), and inability to take four steps at both relevant times (B4). This formula checks the numerical combination, not whether an imaging examination is required.
=IF(OR(COUNT(B2:B4)<>3,AND(B2<>0,B2<>1),AND(B3<>0,B3<>1),AND(B4<>0,B4<>1)),"Invalid or missing ankle inputs",IF(AND(B2=1,OR(B3=1,B4=1)),"Ankle combination present","Ankle combination not present"))Midfoot-zone combination
The foot expression uses the shared B4 finding, midfoot pain B5 and specified foot bone tenderness B6. It validates its own three inputs independently of the ankle expression. Blanks and non-binary values are rejected.
=IF(OR(COUNT(B4:B6)<>3,AND(B4<>0,B4<>1),AND(B5<>0,B5<>1),AND(B6<>0,B6<>1)),"Invalid or missing foot inputs",IF(AND(B5=1,OR(B6=1,B4=1)),"Foot combination present","Foot combination not present"))Try the example
Use the original values or change them to test your understanding.