Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

FIB-4 and APRI: Liver Fibrosis Index Spreadsheet Examples

Compute FIB-4 and APRI from fictional laboratory measurements, checking required inputs and the research context of each index.

Two indices developed in different research populations

FIB-4 combines age, AST, ALT and platelet count; the original 2006 study developed it in people with HIV and hepatitis C coinfection. APRI combines AST relative to its laboratory upper limit of normal with platelet count and was studied in chronic hepatitis C. The indices are used in research and clinical risk assessment, but neither independently establishes a fibrosis stage.

Thresholds depend on the liver disease, age, population and setting. For example, AASLD describes different considerations for younger and older adults with metabolic dysfunction-associated steatotic liver disease (MASLD). A number below one particular cutoff is not an unconditional guarantee that advanced fibrosis is absent.

Fictional inputs (age, AST, ALT, platelets, AST upper limit)FIB-4APRI
58, 84, 64, 130, 404.681.62
38, 26, 36, 250, 400.660.26

FIB-4 arithmetic

Use age in years, AST and ALT in U/L, and platelets in 10^9/L (for example, enter 130 for 130 × 10^9/L). All four values must be numeric and positive. The displayed value is rounded to two decimals; clinical interpretation should not rely on rounded arithmetic alone.

=IF(COUNT(B2:B5)<>4,"Enter all four FIB-4 values",IF(OR(B2<=0,B3<=0,B4<=0,B5<=0),"FIB-4 values must be positive",ROUND((B2*B3)/(B5*SQRT(B4)),2)))

AST-to-platelet ratio index arithmetic

Use the AST and its upper limit of normal in matching units and platelets in 10^9/L. Each value must be numeric and positive. This calculation does not diagnose liver disease or direct additional tests or treatment.

=IF(COUNT(B3,B5,B6)<>3,"Enter all three APRI values",IF(OR(B3<=0,B5<=0,B6<=0),"APRI values must be positive",ROUND((B3/B6)/B5*100,2)))

Try the example

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

Further reading