<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
The one problem with this formula is that the K2 input is not working. For instance if I input m or any value like in this case it states standard. That shouldn’t be…anyone know how to fix that? so that all four match H2, I2, J2, K2 to get the correct output in class L2
| Excel Workbook | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | ft | in | G | standard | standard+ | decline | * | ft | in | weight | G | class | ||
| 2 | 4 | 11 | f | 88 | 116 | 175 | * | 5 | 1 | 150 | m | standard | ||
| 3 | 5 | 0 | f | 90 | 156 | 180 | * | * | * | * | * | * | ||
| 4 | 5 | 1 | f | 93 | 161 | 187 | * | * | * | * | * | * | ||
| 5 | 5 | 2 | f | 97 | 168 | 193 | * | * | * | * | * | * | ||
| 6 | 5 | 3 | f | 100 | 173 | 199 | * | * | * | * | * | * | ||
| 7 | 5 | 4 | f | 102 | 179 | 206 | * | * | * | * | * | * | ||
| 8 | 5 | 5 | f | 106 | 184 | 212 | * | * | * | * | * | * | ||
| 9 | 5 | 6 | f | 110 | 190 | 219 | * | * | * | * | * | * | ||
| 10 | 5 | 7 | f | 113 | 196 | 225 | * | * | * | * | * | * | ||
| 11 | 5 | 8 | f | 116 | 201 | 232 | * | * | * | * | * | * | ||
| 12 | 5 | 9 | f | 119 | 207 | 239 | * | * | * | * | * | * | ||
| 13 | 5 | 10 | f | 123 | 213 | 246 | * | * | * | * | * | * | ||
| 14 | 5 | 11 | f | 127 | 220 | 253 | * | * | * | * | * | * | ||
| 15 | 6 | 0 | f | 130 | 225 | 260 | * | * | * | * | * | * | ||
Sheet | ||||||||||||||
</body></html>
The one problem with this formula is that the K2 input is not working. For instance if I input m or any value like in this case it states standard. That shouldn’t be…anyone know how to fix that? so that all four match H2, I2, J2, K2 to get the correct output in class L2
