How to write a formula for bmiweightheight squared in excel starter if a1 contains weight in kilograms and a2 contains height in meters the correct formula is. Bmi weight kg height 2. For instance the bmi of a person who is 53 and weighs 125 lbs is calculated as follows. The current bmi calculator divides a persons weight by their height to the power of 2 or squared. A1 a22 if weight and height are in other units multiply by an appropriate factor. Body mass index or bmi weight in kilograms height in meters² 703 weight in pounds height in inches².
According to most criteria accepted around the world. A1 a22 which can be written as follows for clarity. Bmi is your weight in kilograms over your height squared in centimeters. 150 652 x 703 2496 source. Body mass index bmi is a value derived from the mass weight and height of a person. The bmi is defined as the body mass divided by the square of the body height and is universally expressed in units of kgm 2 resulting from mass in kilograms and height in metres.
Body mass index bmi is a simple index of weight for height that is commonly used to classify underweight overweight and obesity in adults. Weight lb height in2 x 703 calculate bmi by dividing weight in pounds lbs by height in inches in squared and multiplying by a conversion factor of 703. It is defined as the weight in kilograms divided by the square of the height in meters 1. Weight 150 lbs height 55 65 calculation. If height has been measured in centimeters divide by 100 to convert this to meters. Lets calculate however using pounds and inches.
Body mass index calculator. Weight kg height m 2 the formula for bmi is weight in kilograms divided by height in meters squared.