I need to return a value based on the below table (small sample). If someone is 5' and weighs 97 pounds it returns a BMI of 19....
--------- 19 20
5'------ 97 102
5'2---- 104 109
2007-09-25 04:04:22 · 4 answers · asked by tcmuell 1 in Computers & Internet ➔ Programming & Design
=(A2/((B2*12)*(B2*12))*703)
a2 = weight in pounds
b2 = height in feet
This is the formula that Wikipedia shows for the Body Mass Index.
To verify, it is not 19 that this calculation returns for your results. It is 18.9419444444444
Right click on the cell and select Format Cell. Go to the Number tab and select Number and set your decimal value accordingly.
2007-09-25 08:33:05 · answer #1 · answered by Frank Pytel 4 · 0⤊ 0⤋
try this =If(Iserror(vlookup()),"",vlookup()) - i could preferr this for text fabric or =If(Iserror(vlookup()),0,vlookup()) all the formulae do is that if in case the fee lower back via the vlookup functionality is an errror, it somewhat is replaced via a nil or an empty area. have exciting.
2016-11-06 08:14:04 · answer #2 · answered by Anonymous · 0⤊ 0⤋
BMI = ( Weight in Pounds / ( Height in inches ) x ( Height in inches ) ) x 703
2007-09-25 04:19:19 · answer #3 · answered by AnalProgrammer 7 · 0⤊ 1⤋
Try using the IIF() function of Excel.
IIF(expression, true value, false value)
This function returns the true value if it satisfies the expression or returns the false value if it doesn't.
2007-09-25 04:21:16 · answer #4 · answered by sixths3ns3 1 · 0⤊ 2⤋