![]() ![]() Your ethnic group can also affect your risk of some health conditions. “ 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. ![]() 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: ![]() =CONVERT(B4,"lbm","kg")/ CONVERT(D4,"in","m")^2 Another formula for BMI from pounds and inches 69 inches), the formula is a little simpler. If the height is given in Inches only (e.g. Without the brackets, Excel would square the ‘inches to metres’ Convert() only. 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 with inches /pounds in a BMI calculation looks like this: Based on the above example, the formula is: Converting Feet and Inches into Metresįeet and Inches can be converted into metres in Excel. You can easily convert pounds to kilograms in Excel. Number – Numeric value you require to convert.The US/Imperial measure world needs a little more work, which Excel also handles easily with the CONVERT Function.Įxcel has a Convert function to change one measurement system to another. Weight in Kilos divided by the square of height in metres. You can easily calculate your own BMI in Excel. Another formula for BMI from pounds and inches.It’s easy to calculate in Excel whether you use metric or feet/pounds.īMI can be a polite way of saying how overweight a person is! A BMI over 30 is considered obese and need of work to bring down weight. BMI or Body Mass Index is a ‘rule of thumb’ calculating body fat based on height and weight. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |