Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

HOMA-IR and QUICKI: Fasting Glucose and Insulin Formulas

Calculate the HOMA1-IR approximation in either glucose unit and QUICKI in mg/dL, with explicit units and interpretation limits.

Two indirect indices from fasting measurements

HOMA1-IR is commonly approximated as fasting insulin (µU/mL, numerically equivalent to mU/L) multiplied by fasting glucose in mg/dL and divided by 405. If glucose is in mmol/L instead, use insulin × glucose / 22.5. These forms use the common approximate conversion of 18 mg/dL per mmol/L for glucose.

QUICKI uses 1 / [LOG10(fasting insulin in µU/mL) + LOG10(fasting glucose in mg/dL)]. A glucose value in mmol/L must first be converted to mg/dL for this formula. Both approaches are indirect, fasting-state indices, not direct measurements of tissue insulin sensitivity; the simplified HOMA1 calculation is distinct from the updated HOMA2 model.

No single universal cutoff makes either calculation a diagnosis for every person. Results and interpretation depend on population, assays, glucose and insulin physiology, treatments and other clinical factors. The 1985 HOMA paper reported limited precision, and the original 2000 QUICKI paper evaluated research cohorts. Use the relevant clinical context; this workbook does not diagnose insulin resistance.

Fictional fasting valuesHOMA1-IRQUICKI
Insulin 18 µU/mL; glucose 108 mg/dL (about 6 mmol/L)4.800.3041
Insulin 10 µU/mL; glucose 90 mg/dL (about 5 mmol/L)2.220.3385

HOMA1-IR with glucose in mg/dL

B2 is fasting insulin in µU/mL and B3 is fasting glucose in mg/dL. This formula does not require the mmol/L field.

=IF(COUNT(B2,B3)<>2,"Missing or nonnumeric input",IF(OR(B2<=0,B3<=0),"Enter positive values",ROUND(B2*B3/405,2)))

HOMA1-IR with glucose in mmol/L

B2 is fasting insulin in µU/mL and B4 is fasting glucose in mmol/L. This formula does not require the mg/dL field. If both values are entered, ensure they represent the same measurement; the workbook does not verify that.

=IF(COUNT(B2,B4)<>2,"Missing or nonnumeric input",IF(OR(B2<=0,B4<=0),"Enter positive values",ROUND(B2*B4/22.5,2)))

QUICKI with glucose in mg/dL

B2 and B3 must be positive. The example also rejects a nonpositive logarithmic denominator; logs are evaluated only after the positive-input checks.

=IF(COUNT(B2,B3)<>2,"Missing or nonnumeric input",IF(OR(B2<=0,B3<=0),"Enter positive values",IF(LOG10(B2)+LOG10(B3)<=0,"Outside example domain",ROUND(1/(LOG10(B2)+LOG10(B3)),4))))

Try the example

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

Further reading