adding body mass index calculator into excel

#Adding body mass index calculator into excel how to

These diseases and health conditions include: high blood pressure (hypertension), type 2 diabetes, coronary heart disease (CHD), stroke, musculo-skeletal problems, sleep apnoea and breathing problems and some cancers. Research has shown that people whose BMI falls into the overweight or obese BMI categories are more likely to experience health problems associated with excess weight.

BMI also does not account for pregnant or lactating women and, children and teenagers who are still growing and are not yet physically mature.

BMI for Women tend to have more body fat than BMI for men of equal BMI and older people tend to have more body fat than younger people with the same BMI

Age and sex are not taken into account.

There are height and weight ratio differences between races.

Athletes and body builders who have a high proportion of muscle (muscle weighs more than fat) are categorised with a high BMI.

Limitations of BMIĪlthough there is a correlation between BMI and body fatness, there are limitations of BMI that have been greatly discussed in the medical field. Your doctor will be able to give you advice. If you have a low BMI and you are classified as underweight, then you may want to review your diet with a view to gaining some weight. Your doctor may also offer lifestyle and diet advice to help lower your BMI. These diagnostic tests might include: skinfold thickness and waist measurements, diet and physical activity evaluations, family history and, other appropriate health screenings. If you have a high BMI and you fall into the overweight or obese categories, you should arrange an appointment with your doctor who may recommend further diagnostic tests to explore any health risks. You may want to monitor your BMI on a regular basis to keep abreast and check that you remain in this category. If your BMI figure indicates you are a normal healthy weight that’s great news. The higher your BMI the greater the indication of high body fatness and, excess body fat is known to be linked to both current and future morbidity.

#Adding body mass index calculator into excel how to

How to use BMI figuresīMI is a screening tool of your body fatness and your health. It also offers a useful reference of the BMI weight categories and their corresponding BMI values. Simply tap in your weight and height details in either metric or imperial measurements and this tool will calculate your BMI. The table below is from the WHO and shows the international classification of adult underweight, overweight and obesity according to BMI¹įor ease, you can use our automated BMI calculator. Weight categories can be further classified. Normal healthy weight - BMI between 18.5 and 24.9 x 703 = 24.96 BMI weight categoriesīased on your height and weight, you will be assigned to one of the following weight categories:

If you’re 5’5” (65”) in height and 150lbs in weight, you would calculate your BMI as follows: The imperial BMI formula is your weight in pounds (lbs) divided by your height in inches, squared and then you multiply this figure by a conversion factor of 703.

If you are 175cm (1.75m) in height and 75kg in weight, you can calculate your BMI as follows:ħ5kg / (1.75m²) = 24.49kg/m² Imperial BMI formulaīMI = x 703 To calculate BMI kg the metric formula is your weight in kilograms divided by your height in meters squared. There are two BMI calculation formulas to calculate BMI depending whether you’re using metric or imperial measurements. BMI calculation formula How is BMI calculated ? It offers an inexpensive and simple method of categorising people according to their BMI value so that we can screen people’s weight category and indicate their potential risk for health conditions.

Body mass index (BMI) is a measurement of a person's weight in relation to their height.