Statistical & Clinical Analysis
Mentzer, Green–King and Srivastava Indices: CBC Formulas
Calculate three red-cell discrimination indices using their required CBC inputs and understand their limits as screening aids.
A starting point, not a diagnosis
Mentzer, Green–King and Srivastava indices are arithmetic combinations of complete blood count (CBC) measures studied as aids in evaluating microcytic anemia. Research commonly compares values below 13 for Mentzer, below 65 for Green–King and below 3.8 for Srivastava with values above those thresholds, but performance varies across populations. Borderline values, mixed causes and other conditions cannot be resolved by these indices alone.
A low mean cell volume suggests microcytosis in context; reference ranges vary with age. Iron studies and hemoglobin analysis may be needed, and care decisions require clinical interpretation. A thalassemia trait and iron deficiency may coexist, so the indices must not be used alone to choose or withhold iron.
Mentzer index: MCV / RBC
Enter mean corpuscular volume in fL (B2) and RBC count in millions per µL, numerically equivalent to 10¹²/L (B3). Only these inputs are needed for this index. For 64 fL and 5.8 million/µL, the index is 11.03 to two decimals.
=IF(OR(COUNT(B2:B3)<>2,B2<=0,B3<=0),"Invalid or missing inputs",ROUND(B2/B3,2))Green–King index: MCV² × RDW / (100 × Hb)
Enter RDW as a percent number, for example 13.2 for 13.2%, in B5 and hemoglobin in g/dL in B4. With MCV 64, Hb 11.4 and RDW 13.2, the result is 47.43. With MCV 68, Hb 9.2 and RDW 18.5, it is 92.98.
=IF(OR(COUNT(B2,B4:B5)<>3,B2<=0,B4<=0,B5<=0),"Invalid or missing inputs",ROUND(B2^2*B5/(100*B4),2))Srivastava index: MCH / RBC
Enter mean corpuscular hemoglobin in pg in B6 and RBC count in millions/µL in B3. For MCH 19.7 pg and RBC 5.8 million/µL, the result is 3.40 to two decimals. All inputs used by each formula must be positive numbers.
=IF(OR(COUNT(B3,B6)<>2,B3<=0,B6<=0),"Invalid or missing inputs",ROUND(B6/B3,2))Try the example
Use the original values or change them to test your understanding.