Arte SheetsLearn. Try. Understand.

Statistical & Clinical Analysis

IPI and R-IPI for Lymphoma: Scores, Groups and Context

Count five historical lymphoma prognostic factors and compare classic IPI and R-IPI groupings with complete example inputs.

Two ways to group the same five factors

The International Non-Hodgkin’s Lymphoma Prognostic Factors Project developed the IPI in 1993 using outcomes in 2,031 people with aggressive lymphoma. The five pretreatment factors are age over 60 years, advanced stage III or IV, LDH above the upper limit of normal, performance status of at least 2, and more than one involved extranodal site. Each factor contributes one point.

The original IPI groups totals as 0–1, 2, 3 and 4–5. In 2007 Sehn and colleagues studied diffuse large B-cell lymphoma treated with R-CHOP and regrouped those same totals into R-IPI categories of 0, 1–2 and 3–5. Their reported four-year overall survival values were 94%, 79% and 55%, respectively, in that study. These are historical group outcomes, not individual predictions, and performance varies across populations and treatment eras.

A prognostic score is neither a lymphoma diagnosis nor an automatic instruction to intensify treatment or provide prophylaxis. Specialists evaluate the type and extent of disease, treatment options and patient-specific factors together.

Count pre-assessed factors

Enter one binary flag for each of the five assessed factors in B2:B6; 1 means present and 0 means confirmed absent. Unknown findings must not be entered as zero. COUNT requires all five numerical values and the remaining checks reject non-binary or fractional flags.

=IF(COUNT(B2:B6)<>5,"Enter all five numeric flags",IF(OR(MIN(B2:B6)<0,MAX(B2:B6)>1,INT(B2)<>B2,INT(B3)<>B3,INT(B4)<>B4,INT(B5)<>B5,INT(B6)<>B6),"Flags must be 0 or 1",SUM(B2:B6)))

Map to a classic IPI group

The same complete set of flags maps to one of the four original IPI labels.

=IF(COUNT(B2:B6)<>5,"Enter all five numeric flags",IF(OR(MIN(B2:B6)<0,MAX(B2:B6)>1,INT(B2)<>B2,INT(B3)<>B3,INT(B4)<>B4,INT(B5)<>B5,INT(B6)<>B6),"Flags must be 0 or 1",IF(SUM(B2:B6)>=4,"Classic IPI: high",IF(SUM(B2:B6)=3,"Classic IPI: high-intermediate",IF(SUM(B2:B6)=2,"Classic IPI: low-intermediate","Classic IPI: low")))))

Map to a revised R-IPI group

The R-IPI regroups the identical five-factor total into three labels. These examples do not establish the underlying findings, forecast an individual outcome or direct treatment, and have not been clinically validated.

=IF(COUNT(B2:B6)<>5,"Enter all five numeric flags",IF(OR(MIN(B2:B6)<0,MAX(B2:B6)>1,INT(B2)<>B2,INT(B3)<>B3,INT(B4)<>B4,INT(B5)<>B5,INT(B6)<>B6),"Flags must be 0 or 1",IF(SUM(B2:B6)=0,"R-IPI: very good",IF(SUM(B2:B6)<=2,"R-IPI: good","R-IPI: poor"))))

Try the example

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

Further reading