Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

ALBI Score and Grade: Research Context and Spreadsheet Arithmetic

Understand the albumin-bilirubin score and reproduce its published three-grade cut points with fictional values.

The model and its original setting

Johnson and colleagues developed the albumin–bilirubin (ALBI) score in an international study of patients with hepatocellular carcinoma. The model uses a logarithm of serum bilirubin in µmol/L and serum albumin in g/L. Its three grades were associated with different survival outcomes in the studied cohorts.

ALBI is one part of liver-function assessment, not a stand-alone diagnosis of decompensation or a guarantee of suitability for surgery or any medication. The original authors’ grades describe a research model and must be interpreted in the relevant clinical context.

Grade in the original paperCut point for the unrounded score
1≤ −2.60
2> −2.60 and ≤ −1.39
3> −1.39

Calculate the score in the published units

Enter fictional total bilirubin in µmol/L and albumin in g/L. The formula checks that both are numeric and positive. It does not check laboratory reliability, appropriate units, clinical plausibility or whether the model applies. The raw value is retained in E2; the display in F2 rounds it to three decimal places.

=IF(COUNT(B2:B3)<>2,"Enter both numeric values",IF(OR(B2<=0,B3<=0),"Both inputs must be positive",IFERROR(0.66*LOG10(B2)-0.085*B3,"Values outside calculation range")))

Use the unrounded score for its grade

The grade formula reads the unrounded value in E2, so a displayed rounded value of −2.600 can still belong to Grade 2 if the actual value is slightly greater than −2.60. The grade alone does not prescribe a clinical action.

=IF(ISTEXT(E2),E2,IF(E2<=-2.6,"Grade 1",IF(E2<=-1.39,"Grade 2","Grade 3")))

Try the example

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

Further reading