Hi Guys,
Chose the right box to store Part A which has volume of 2.7
<tbody>
Box name(Column A)
Box Volume(Column B)
b1
1
b2
2
b3
3
</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...