ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   BMI Template (https://www.excelbanter.com/excel-discussion-misc-queries/82370-bmi-template.html)

jj358mhz

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

If not, how about conversion factors in the formulae?

Gary''s Student

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?



All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com