Arte SheetsLearn. Try. Understand.

Clinical Medicine & Physiology

Lipid Accumulation Product: A Waist and Triglyceride Spreadsheet Example

Learn how Kahn’s sex-specific lipid accumulation product combines waist circumference and fasting triglycerides, and why its numerical value is not a diagnosis.

A population-derived index, not a fat measurement

Kahn’s 2005 analysis used NHANES III data on 9,180 adults to study a waist-and-triglyceride index in relation to cardiovascular risk factors. The index is (waist in cm − 65) × triglycerides in mmol/L for men and (waist in cm − 58) × triglycerides in mmol/L for women. The sex-specific offsets represent estimated origins in the study’s population, not physiological minimum waist sizes for all individuals.

LAP is a calculated marker, not a direct measurement of liver or visceral fat. Study associations do not establish a universal cutoff that diagnoses metabolic dysfunction-associated steatotic liver disease or determines an individual’s risk. Interpretation depends on the population, outcome and clinical context.

Study group and waistTriglycerides (mmol/L)LAP arithmetic (cm·mmol/L)
Male group; 79 cm0.9012.60
Male group; 101 cm2.2079.20
Female group; 90 cm1.8559.20

Calculate LAP for the example

Enter M or F for the original study group in B2, waist circumference in centimetres in B3, and fasting triglycerides in mmol/L in B4. The example requires positive triglycerides and a waist above the equation’s group-specific offset; limits of 200 cm and 35 mmol/L are exercise guards, not validated clinical boundaries.

The original study adjusted five male waist measurements at or below 65 cm to 66 cm for its population analysis. This example instead asks the reader to review such inputs; it does not silently alter measurements.

=IF(COUNT(B3:B4)<>2,"Enter numeric waist and triglycerides",IF(OR(AND(B2<>"M",B2<>"F"),B3<=IF(B2="M",65,58),B3>200,B4<=0,B4>35),"Check example inputs",ROUND((B3-IF(B2="M",65,58))*B4,2)))

Convert triglycerides from mg/dL when necessary

If a triglyceride value is reported in mg/dL, enter it separately in B5 and divide by 88.57 to obtain approximately mmol/L. Confirm the laboratory units before entering B4.

=IF(COUNT(B5)<>1,"Enter numeric triglycerides",IF(B5<=0,"Check triglycerides",B5/88.57))

Try the example

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

Further reading