Help with figuring formula to figure BMI

D

DebO

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.
 
G

Gary''s Student

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

=A1*703/(B1)^2

For example:

200 75 24.99555556
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Homework Help 2
if then formula 3
Formula needed 2
Excel Stop Excel from displaying rounded values 4
Calculating something that will not be changing 19
Auto Fill Format or Copying Formulas 1
Excel Getting an annualized figure based on YTD in Excel 1
The right formula is? 2

Top