
Quetelet developed the height-to-weight equation as a way to help determine an ideal weight for populations in general, not necessarily for individuals.īut because BMI is an accessible-albeit impercise-tool, it’s been adopted by the healthcare community and scientific researchers as a way of indicating the relative amount of body fat on a person’s body frame, and assessing if a person is at a healthy weight for their height. Other factors to consider include your age, gender, weight distribution, family medical history and lifestyle.Īdolphe Quetelet, a mathematician, first developed BMI and named it decades ago-it was first cited in 1972 in the Journal of Chronic Diseases. “It’s a base assessment,” says Jamie Feit, a registered dietitian at, which offers at-home and lab testing information and resources. That’s why BMI alone should not be the only factor considered when gauging if you’re at a healthy weight.

While it’s designed to estimate whether you have excess or inadequate body fat, it does not measure fat directly-therefore it does not provide the whole picture for some people. BMI Chart For Men And Women: Your Guide To This Common Health MetricīMI is a tool that helps determine whether you’re at a healthy weight in relation to your height-but “tool” is the operative word. While we work hard to provide accurate and up-to-date information that we think you will find relevant, Forbes Health does not and cannot guarantee that any information provided is complete and makes no representations or warranties in connection thereto, nor to the accuracy or applicability thereof. The compensation we receive from advertisers does not influence the recommendations or advice our editorial team provides in our articles or otherwise impact any of the editorial content on Forbes Health. Second, we also include links to advertisers’ offers in some of our articles these “affiliate links” may generate income for our site when you click on them. This site does not include all companies or products available within the market. The compensation we receive for those placements affects how and where advertisers’ offers appear on the site. First, we provide paid placements to advertisers to present their offers. This compensation comes from two main sources.
BODY MASS INDEX CALCULATOR IN INCHES FOR FREE
To help support our reporting work, and to continue our ability to provide this content for free to our readers, we receive compensation from the companies that advertise on the Forbes Health site. Also remember, Excel performs exponentiation (^) before multiplication (*) and division (/).The Forbes Health editorial team is independent and objective. If a part of the formula is in parentheses, that part will be calculated first. Excel uses a default order in which calculations occur. Using standard units, BMI = 703*pounds/inches^2. Create a conditional formatting rule that changes the format of cell C10 when you select Metric from the drop-down list (step 6, 7 and 8).Įxplanation: C9*12+C10 calculates the height in inches and C9/100 calculates the height in meters. The IF function in cell D10 returns an empty string. Insert an IF function into cell D7, D9 and D10 to show the correct units.ģ.

To create this BMI calculator, execute the following steps.Ģ.

BODY MASS INDEX CALCULATOR IN INCHES HOW TO
We assume that you know how to change font sizes, font styles, insert rows and columns, add borders, change background colors, etc. Note: the instructions below do not teach you how to format the worksheet.
