View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.