Hi,
New to the forum as I have a problem with a work sheet that has been bugging me all day.
For example
I want cell H5 to return the number of pallets it would require depending on the number of cases (I5)
We can fit 126 cases onto a pallet so if I5 is between 1 and 126 then H4 should return 1. I need to be able to do this up to 10 pallets and with the nested if forumluas I got to 7 and would let me add anymore.
<colgroup><col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
New to the forum as I have a problem with a work sheet that has been bugging me all day.
For example
I want cell H5 to return the number of pallets it would require depending on the number of cases (I5)
We can fit 126 cases onto a pallet so if I5 is between 1 and 126 then H4 should return 1. I need to be able to do this up to 10 pallets and with the nested if forumluas I got to 7 and would let me add anymore.
Cases | pallets |
0-126 | 1 |
127-252 | 2 |
253-378 | 3 |
379-504 | 4 |
505-630 | 5 |
631-756 | 6 |
757-882 | 7 |
883-1008 | 8 |
1009-1134 | 9 |
1135-1260 | 10 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>