MrExcel Message Board

Logistics Formula. cdowd said: Aug 13th, 2010 12:43 AM. Logistics Formula. I work in the logistics department at work and have an excel sheet that lists the following: 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! Sandeep Warrier said: Aug 13th, 2010 01:06 AM. Re: Logistics Formula. In the solution given below, I am first checking for the weight of 60 pallets. If the number is higher than the weight limit then calculate the number of trucks based on weight otherwise calculate it based on number of pallets. Is this logic OK for you?