Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Formulas

YEARS Study: Exploring Conditional D-Dimer Thresholds in a Spreadsheet

Learn how the 2017 YEARS study combined three clinical items with different D-dimer thresholds, and practice numeric comparisons without using a spreadsheet to diagnose pulmonary embolism.

What the study evaluated

In the 2017 prospective YEARS study, clinicians assessed three items in adults with suspected pulmonary embolism (PE): signs of deep vein thrombosis, coughing blood, and whether PE was the most likely diagnosis. The study used a D-dimer threshold below 1,000 ng/mL in those with no items and below 500 ng/mL in those with one or more items; other participants underwent CT pulmonary angiography in the study protocol.

The original study excluded pregnancy and some other groups. Pregnancy-adapted YEARS is a different pathway; age-adjusted D-dimer is another approach and is not calculated here. D-dimer assays and reported units differ; these study values use ng/mL fibrinogen-equivalent units (FEU), not D-dimer units (DDU). A trained clinician must determine the appropriate test and pathway.

Of 2,946 participants in whom PE was considered excluded at baseline and who remained untreated, 18 had symptomatic venous thromboembolism during three months of follow-up (0.61%). This group included people evaluated with and without CT. CT was not indicated in 48% by the study strategy versus 34% in a comparison with Wells and a fixed cutoff, an absolute difference of 14 percentage points, not proof that every avoided scan was unnecessary.

Number of study itemsIllustrative study thresholdExample result 740 ng/mL FEU
01,000 ng/mLNumerically below
1 or more500 ng/mLNumerically at or above

Choose a threshold from three complete flags

For this educational exercise, enter numeric 0 or 1 in B2:B4. The sample formula returns a number only when all three flags are present and valid. Whether a real clinical item applies, especially the most-likely-diagnosis item, requires a clinician’s assessment.

=IF(COUNT(B2:B4)<>3,"Complete the three numeric flags",IF(COUNTIF(B2:B4,0)+COUNTIF(B2:B4,1)<>3,"Use only 0 or 1",IF(SUM(B2:B4)=0,1000,500)))

Compare a fictional measurement

Enter a fictional nonnegative D-dimer value in ng/mL FEU in B5. The formula compares it with the example threshold; equality is counted as at or above. Missing or nonnumeric values cannot yield a below-threshold label.

This workbook is an illustration of IF and validation, not a validated diagnostic device. It does not rule out PE or decide whether imaging or treatment is needed. Suspected PE needs prompt clinical evaluation; serious symptoms such as sudden breathlessness or chest pain warrant urgent medical attention.

=IF(COUNT(B2:B5)<>4,"Complete all numeric inputs",IF(COUNTIF(B2:B4,0)+COUNTIF(B2:B4,1)<>3,"Use only 0 or 1 for flags",IF(B5<0,"Check the value",IF(B5<IF(SUM(B2:B4)=0,1000,500),"Below example threshold","At or above example threshold"))))

Try the example

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

Further reading