Calculate your body mass index. Select compute bmi and your bmi will appear below. Next you have to write down your weight which is your current weight. The standard bmi formula is. From the formula to calculate bmi. First you have to write your height.

Next fill in the excel formula for calculating the bmis for each measuring system. This example shows one way to calculate bmi body mass index in excel. You would type in this formula as it corresponds to which excel cells you are using in your spreadsheet. Bmi weight kg height m2. The formula for the english bmi is weight multiplied by 703 which is just a conversion factor divided by height squared. 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.

Place the cursor in the first empty box under column f for bmi and enter the following. Bmi is an abbreviation for body mass index. C912c10 calculates the height in inches and c9100 calculates the height in meters. Using metric units bmi kgm2. Function bmiweight height bmi weight height 100 2 end function close the vbe window and back to excel. Body mass index bmi is a measure of body fat based on height and weight that applies to adult men and women.

If a part of the formula is in parentheses that part will be calculated first. Using standard units bmi 703poundsinches2. Create the bmi formula. Enter your weight and height using standard or metric measures. Click on the bottom right hand corner of box f2 and drag down to copy the equation for all participants. 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.

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. Now lets turn to the ideal weight calculator that you can see in the picture below the formula is b3 10009. Look up the bmi in a table to determine body mass index status. Remember that the height is in centimeters. Excel uses a default order in which calculations occur. See the resources section for this information.

Then save the file with click on save button or press ctrls on your keyboard so the save as dialog box is displayed.

Gallery of How To Calculate Bmi From Height And Weight In Excel