1/18/2023 0 Comments Bmi calculator inches and pounds![]() ![]() They also note, though it hardly needs mentioning, that the BMI isn’t relevant for pregnant women, children or teenagers. your weight in pounds by 703, then divide the result by your height in inches. For example, adults of South Asian origin may have a higher risk of some health problems, such as diabetes, with a BMI of 23, which is usually considered healthy. A BMI Metric Calculator uses a weight-to-height ratio (BMI kg/m2) and. Your ethnic group can also affect your risk of some health conditions. Using standard units, BMI 703pounds/inches2. “ Muscle is much denser than fat, so very muscular people, such as heavyweight boxers, weight trainers and athletes, may be a healthy weight even though their BMI is classed as obese. Explanation: C912+C10 calculates the height in inches and C9/100 calculates the height in meters. The British NHS has some good advice about BMI The BMI needs to be treated with care because it doesn’t apply to everyone. See BMI calcs can do more in Excel About BMI – Body Mass IndexīMI is a broad screening tool for determining if an adult is obese, overweight, or underweight. In US measures there are three parameters for weight, height in feet and height in inches:ĬONVERT(wgtlbm,"lbm","kg")/ (CONVERT(hgtFt,"ft","m")+CONVERT(hgtIn,"in","m")^2)) ) Conditional FormattingĪs you can see above, some conditional formatting can highlight results outside the healthy range with coloured cells or other formatting tricks. Lambda( weight, height, weight/height^2 ) If there are a lot of BMI calculations in your worksheet, especially the conversion ones, you could make your own BMI() formula using Lambda() =(Weight / Height^2) * 703 Lambda option for BMI (Weight in Pounds / Height in inches 2 ) x 703 ![]() There is another way to get a BMI from pounds and inches: 69 inches), the formula is a little simpler. The metric formula for BMI is weight in kilograms divided by height in. If the height is given in Inches only (e.g. When using imperial pounds and inches the formula needs altering slightly to. For instance, if you’re 5 feet and 10 inches tall, you’d multiply 5 by 12 to get 60 and then add 10 to obtain 70 inches. Multiply the number of feet tall you are by 12 to get your height in inches. Without the brackets, Excel would square the ‘inches to metres’ Convert() only. Because muscle is denser than fat, athletes with a large amount of muscle frequently have a BMI that defines them as overweight. The brackets are necessary because Excel’s order of precedence will do ‘raising to a power’ or squaring first. =CONVERT(C4,"ft","m")+CONVERT(D4,"in","m") BMI in Excel for Feet and PoundsĪ single formula for using feet/pounds in a BMI calculation looks like this: The BMI equals a person's weight in kilograms divided by height in meters squared. Based on the above example, the formula is: The BMI is calculated with a mathematical formula that takes into account not just a person's weight but also height. Converting Feet and Inches into Metresįeet and Inches can be converted into metres in Excel. Weight in pounds (lb): Height in inches (in). Based on the above example, the formula is: ShareBody mass index (BMI) is a measure of body fat based on weight and height that applies to adult men. You can easily convert pounds to kilograms in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |