First you have to write your height. From the formula to calculate bmi. Enter your weight and height using standard or metric measures. Excel uses a default order in which calculations occur. Calculate your body mass index. This example shows one way to calculate bmi body mass index in excel.
Body mass index bmi is a measure of body fat based on height and weight that applies to adult men and women. This makes it easy to collect height and weight in commonly used units in the united states and also show the metric amounts used in the calculation. Look up the bmi in a table to determine body mass index status. Remember that the height is in centimeters. Next you have to write down your weight which is your current weight. If a part of the formula is in parentheses that part will be calculated first.
Click on the bottom right hand corner of box f2 and drag down to copy the equation for all participants. Using metric units bmi kgm2. Now lets turn to the ideal weight calculator that you can see in the picture below the formula is b3 10009. Select compute bmi and your bmi will appear below. Bmi weight kg height m2. Next fill in the excel formula for calculating the bmis for each measuring system.
The standard bmi formula is. Then save the file with click on save button or press ctrls on your keyboard so the save as dialog box is displayed. We can define it as a value thats derived from the weight and height of a person to determine whether a person is underweight normal weight or obese based on that value. Place the cursor in the first empty box under column f for bmi and enter the following. The formula for the english bmi is weight multiplied by 703 which is just a conversion factor divided by height squared. Create the bmi formula.
The approach used here is to first convert height in inches and feet to meters and weight in pounds to kilograms then use the standard metric formula for bmi. See the resources section for this information. Bmi is an abbreviation for body mass index. You would type in this formula as it corresponds to which excel cells you are using in your spreadsheet. Function bmiweight height bmi weight height 100 2 end function close the vbe window and back to excel. Using standard units bmi 703poundsinches2.
C912c10 calculates the height in inches and c9100 calculates the height in meters.
Gallery of How To Calculate Bmi From Height And Weight In Excel
