Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Forns Index Non-Invasive Liver Fibrosis Calculator (Platelets, GGT, Cholesterol)

Calculate the Forns liver fibrosis index from platelet count, GGT, age and total cholesterol, and understand the original chronic-hepatitis-C study context and thresholds.

A model developed for chronic hepatitis C

The Forns index combines platelet count (10⁹/L), gamma-glutamyl transferase or GGT (IU/L), age (years), and total cholesterol (mg/dL). Enter a platelet count of 135,000/µL as 135 × 10⁹/L; cholesterol in mmol/L requires conversion to mg/dL before use.

Forns and colleagues developed the index in adults with chronic hepatitis C. In their 2002 study, a score below 4.2 had a 96% negative predictive value for biopsy-defined significant fibrosis (F2–F4) in the studied cohort; the external validation group was also reported. Predictive values depend on the population and disease prevalence. A low result does not establish that an individual has no fibrosis.

The historic high cutoff is above 6.9; values from 4.2 through 6.9 are an intermediate range in this example. Neither cutoff confirms or excludes disease by itself or prescribes a test. Clinical use depends on etiology, other findings and current local guidance. The displayed value is rounded to two decimals; the threshold formula compares the unrounded value.

Illustrative inputs: platelets, GGT, age, cholesterolCalculated indexHistoric cutoff range
135 × 10⁹/L, 92 IU/L, 54 years, 175 mg/dL7.36Above 6.9
200 × 10⁹/L, 50 IU/L, 50 years, 170 mg/dL5.464.2 to 6.9
260 × 10⁹/L, 28 IU/L, 36 years, 195 mg/dL2.70Below 4.2

Calculate the Forns index

All four values must be numeric and positive; the logarithms require positive platelet count, GGT and age. Total cholesterol is entered in mg/dL.

=IF(COUNT(B2:B5)<>4,"Missing or nonnumeric input",IF(OR(B2<=0,B3<=0,B4<=0,B5<=0),"Invalid input",ROUND(7.811-3.131*LN(B2)+0.781*LN(B3)+3.467*LN(B4)-0.014*B5,2)))

Compare the unrounded index with historic thresholds

This labels the numerical range only. A result in a given range is not a diagnosis and does not alone establish what procedure or treatment a person needs.

=IF(COUNT(B2:B5)<>4,"Missing or nonnumeric input",IF(OR(B2<=0,B3<=0,B4<=0,B5<=0),"Invalid input",IF((7.811-3.131*LN(B2)+0.781*LN(B3)+3.467*LN(B4)-0.014*B5)<4.2,"Below 4.2",IF((7.811-3.131*LN(B2)+0.781*LN(B3)+3.467*LN(B4)-0.014*B5)>6.9,"Above 6.9","4.2 to 6.9"))))

Try the example

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

Further reading