<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
I want to match H2 & I2 to columns A3:A5 & B3:B5 and in J3 I want to be able round to the nearest number like in this case it would be 100. In J6 it would show a BMI of 21. If J2 was 97 then the BMI would be 20.
Anyone know how to do that?
Excel Workbook | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | BMI | * | 19 | 20 | 21 | 22 | * | Ft | In | lbs | ||
2 | Ft | In | Body Weight | * | 4 | 10 | 99 | |||||
3 | 4 | 10 | 91 | 96 | 100 | 105 | * | * | * | * | ||
4 | 4 | 11 | 94 | 99 | 104 | 109 | * | * | * | * | ||
5 | 5 | 0 | 97 | 102 | 107 | 112 | * | * | * | BMI | ||
6 | * | * | * | * | * | * | * | * | * | * | ||
Sheet |
</body></html>
I want to match H2 & I2 to columns A3:A5 & B3:B5 and in J3 I want to be able round to the nearest number like in this case it would be 100. In J6 it would show a BMI of 21. If J2 was 97 then the BMI would be 20.
Anyone know how to do that?