ExcelBanter - Help with figuring formula to figure BMI

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with figuring formula to figure BMI (https://www.excelbanter.com/excel-discussion-misc-queries/222938-help-figuring-formula-figure-bmi.html)

Debo

Help with figuring formula to figure BMI

I've been asked to create a spreadsheet that incudes a BMI (Body Mass Index)
calculator in it and have not been able to figure out the correct formula,
nor how the cell rounds correctly. Any help will be greatly appreciated.

Gary''s Student

Help with figuring formula to figure BMI

With weight in lbs in A1 and height in inches in B1:

=A1*703/(B1)^2

For example:

200 75 24.99555556

--
Gary''s Student - gsnu200836

"DebO" wrote:

I've been asked to create a spreadsheet that incudes a BMI (Body Mass Index)
calculator in it and have not been able to figure out the correct formula,
nor how the cell rounds correctly. Any help will be greatly appreciated.

All times are GMT +1. The time now is 07:53 AM.