Generic filters

Body Mass Index Chart(BMI) Excel Template

BMI Chart or Body Mass Index Chart is a useful tool for visualizing the ranges for underweighthealthy weight, overweight, and obesity based on an individual height. The simplicity of Body Mass Index chart formula has made it extremely popular as an initial diagnosing tool for determining a person’s healthy body weight. The formula does have its demerits because it does not take into account age, frame size, gender, or muscularity.

There are many other formulas besides the BMI that are used for determining ideal weight. Our Ideal Weight Chart includes some additional formulas, but keep in mind that “ideal” weight can be highly subjective, and formulas are usually approximations. Also check out our Weight Loss Charts.

BMI calculator kg

This spreadsheet contains a BMI calculator that uses both the CDC and the NHANES II definitions for BMI. The chart shows your BMI on the spectrum based on the chosen formula and gender. This spreadsheet also contains a worksheet use for creating the BMI charts.

Technically, the CDC and NHANES II definitions use the same BMI formula. It’s only the range of values for each category that is different for each other.

The BMI Formula

BMI is defined as a person’s weight divided by the square of a person’s height, using the metric units kg/m^2.

  • Metric Units: BMI = Weight[kg] / ( Height[m] x Height[m] )
  • English Units: 703 x Weight[lb] / ( Height[in] x Height[in] )

BMI Chart for Children

BMI is calculated the same way for children as for adults, but the way for determining a “normal” weight is different. Replacement of specific BMI thresholds, a BMI percentile is used to compare to other children of the same age and gender. Just as there are Weight-for-Age, Height-for-Age, and Head Circumference-for-Age growth charts, there are also BMI-for-Age charts.

For children, the weight status category is defined based on the BMI percentile (less than the 5th percentile, 5th to less than the 85th, 85th to less than the 95th, and equal to or greater than 95th, respectively).

What is the correct BMI for my age?

Height: Weight: Your BMI is , indicating your weight is in the category for adults of your height. For your height, a healthy weight range would be from to pounds.
Adult BMI Calculator.
BMI Weight Status
Below 18.5 Underweighted
18.5—24.9 Healthy
25.0—29.9 Overweighed
30.0 and Above Obesity
Download Body Mass Index Chart(BMI) Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: