Arte SheetsLearn. Try. Understand.

Clinical Medicine & Physiology

Conicity Index and Waist-to-Height Ratio: Two Spreadsheet Examples

Calculate Valdez’s conicity index and waist-to-height ratio from consistent units, with clear distinctions between geometric models and health guidance.

Two measures of waist relative to body size

Valdez’s conicity index compares waist circumference with the circumference of a model cylinder estimated from height and weight: waist in metres divided by 0.109 × square root of weight in kilograms divided by height in metres. The cylinder and double cone are idealized geometric models; real bodies need not be either shape, and the index does not directly measure visceral fat.

Waist-to-height ratio divides waist by height using the same length unit. NICE recommends considering this ratio alongside BMI for adults with BMI below 35, and discusses a ratio below 0.5 as a public-health message. A ratio is one part of assessment, not a complete diagnosis or an individual guarantee of low risk.

Height; weight; waistConicity indexWaist / height
180 cm; 75 kg; 78 cm1.10860.4333
175 cm; 82 kg; 91 cm1.21960.5200
172 cm; 86 kg; 106 cm1.37530.6163

Calculate the conicity index

Enter height in centimetres in B2, weight in kilograms in B3 and waist in centimetres in B4. The formula converts height and waist to metres. The numerical input limits are exercise guards; they do not validate the estimate or select a clinical risk threshold.

=IF(COUNT(B2:B4)<>3,"Enter numeric height, weight and waist",IF(OR(B2<100,B2>240,B3<25,B3>300,B4<40,B4>200),"Check example inputs",ROUND((B4/100)/(0.109*SQRT(B3/(B2/100))),4)))

Calculate waist-to-height ratio

The ratio uses B2 and B4 in the same units and does not require body weight. Interpretation depends on the applicable guidance and the whole clinical context.

=IF(COUNT(B2,B4)<>2,"Enter numeric height and waist",IF(OR(B2<100,B2>240,B4<40,B4>200),"Check example inputs",ROUND(B4/B2,4)))

Try the example

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

Further reading