Hi Guys,
Chose the right box to store Part A which has volume of 2.7
<tbody>
</tbody>
Based on on above table i would use an if conditions which goes like this,
=IF($F$1<=B2,A2,IF($F$1<=B3,A3,IF($F$1<=B4,A4)))
is there any other alternative instead of using IF function. the above example contains 3 rows, however in reality i would need to apply IF func for 100+ rows. Please help.
Chose the right box to store Part A which has volume of 2.7
Box name(Column A) | Box Volume(Column B) |
b1 | 1 |
b2 | 2 |
b3 | 3 |
<tbody>
</tbody>
Based on on above table i would use an if conditions which goes like this,
=IF($F$1<=B2,A2,IF($F$1<=B3,A3,IF($F$1<=B4,A4)))
is there any other alternative instead of using IF function. the above example contains 3 rows, however in reality i would need to apply IF func for 100+ rows. Please help.