Thread: BMI Template
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default BMI Template

Let's input the English units and do the metric conversions
In A1 thru E1 enter:

160 =A1/2.204622622 6 =C1/3.280839895 =B1/(D1*D1)

A1 the weight in lbs (entered)
B1 the weight in kg (calculated)
C1 the height in feet (entered)
D1 the height in m (calculated)
E1 the BMI (calculated)

You will see:

160 72.5747792 6 1.8288 21.69967838

(under 25 is not so bad)
--
Gary's Student


"jj358mhz" wrote:

Does anyone know of the BMI template being available using the US number
system?

If not, how about conversion factors in the formulae?