Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

Canadian C-Spine Rule Research and a Nested IF Example

Review the scope of the Canadian C-Spine Rule study and learn sequential spreadsheet branching with fictional flags.

What the original study examined

Stiell and colleagues developed the Canadian C-Spine Rule in an emergency-department cohort of 8,924 assessed patients with potential blunt neck or head trauma. Trained clinicians evaluated sequential high-risk factors, low-risk factors and, when appropriate, active rotation. The published sensitivity was a study estimate, not a guarantee for every injury or population.

Eligibility in the derivation study required an alert, stable patient at risk after acute blunt trauma. Exclusions included age under 16, penetrating trauma, acute paralysis, certain known vertebral diseases, pregnancy, injury over 48 hours earlier and reassessment of the same injury; see the complete original eligibility criteria. Practice guidance may differ by setting and change over time.

Research stepWhat the study assessed
FirstHigh-risk factors including older age, dangerous mechanism or extremity paresthesias
SecondLow-risk factors considered before a clinician assesses movement
ThirdAbility to rotate the neck actively to both sides, when appropriate

Practice sequential IF logic safely

The following is a generic programming exercise with three fictional 0-or-1 flags. It returns a branch label, not a patient assessment. For example, B2 = 1 selects Branch A before the other two flags are considered; otherwise B3 and then B4 select the remaining branches. All three values are required and checked as binary numbers.

This demonstration cannot determine whether a rule applies, whether a neck examination or imaging is appropriate, or whether a spine is cleared. A person with a possible spinal injury should be assessed by trained professionals using current guidance; do not test neck movement based on this spreadsheet.

=IF(COUNT(B2:B4)<>3,"Enter all three numeric flags",IF(OR(MIN(B2:B4)<0,MAX(B2:B4)>1,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0),"Each flag must be 0 or 1",IF(B2=1,"Branch A",IF(B3=0,"Branch B",IF(B4=0,"Branch C","Branch D")))))

Try the example

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

Further reading