Hi guys,
I work in the logistics department at work and have an excel sheet that lists the following:
<table style="border-collapse: collapse; width: 413pt;" width="549" border="0" cellpadding="0" cellspacing="0"><col style="width: 59pt;" width="78"> <col style="width: 70pt;" width="93"> <col style="width: 68pt;" width="90"> <col style="width: 72pt;" width="96" span="3"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 59pt;" width="78" height="20">
</td> <td style="width: 70pt;" width="93">
</td> <td style="width: 68pt;" width="90">
</td> <td style="width: 72pt;" width="96">
</td> <td style="width: 72pt;" width="96">
</td> <td style="width: 72pt;" width="96">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">A
</td> <td class="xl66" style="border-left: medium none;">B
</td> <td align="right">C
</td> <td class="xl67" align="right">D
</td> <td class="xl68" align="right">E
</td> <td>
</td> </tr> </tbody></table>1 Item#: # of Cases: Cases per Plt: # of Pallets: Weight per Plt:
2 035927 11770.00 70 168 818.3lbs
I want to have a cell after this called "#of trucks". Under that cell I want a formula that can calculate the number of trucks needed to deliver the 168 pallets.
Here is the criteria:
The truck can hold up to 60 pallets per truck or 43,500lbs...whichever comes first.
I tried using a couple imbedded IF functions but couldn't seem to get it to work. Any help would be appreciated. Thanks so much!
I work in the logistics department at work and have an excel sheet that lists the following:
<table style="border-collapse: collapse; width: 413pt;" width="549" border="0" cellpadding="0" cellspacing="0"><col style="width: 59pt;" width="78"> <col style="width: 70pt;" width="93"> <col style="width: 68pt;" width="90"> <col style="width: 72pt;" width="96" span="3"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 59pt;" width="78" height="20">
</td> <td style="width: 70pt;" width="93">
</td> <td style="width: 68pt;" width="90">
</td> <td style="width: 72pt;" width="96">
</td> <td style="width: 72pt;" width="96">
</td> <td style="width: 72pt;" width="96">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">A
</td> <td class="xl66" style="border-left: medium none;">B
</td> <td align="right">C
</td> <td class="xl67" align="right">D
</td> <td class="xl68" align="right">E
</td> <td>
</td> </tr> </tbody></table>1 Item#: # of Cases: Cases per Plt: # of Pallets: Weight per Plt:
2 035927 11770.00 70 168 818.3lbs
I want to have a cell after this called "#of trucks". Under that cell I want a formula that can calculate the number of trucks needed to deliver the 168 pallets.
Here is the criteria:
The truck can hold up to 60 pallets per truck or 43,500lbs...whichever comes first.
I tried using a couple imbedded IF functions but couldn't seem to get it to work. Any help would be appreciated. Thanks so much!
Last edited: