I have a question about some nested if statements. The formula has gotten so big i'm having a lot of problems trouble shooting it with my limited experience. Im not even sure all these IF statements are the way to go. Maybe once I tell you what i tried to do it will help: Basically, i have X amount of bins available to ship. I have x amount of trucks. each truck hold X amount of weight and bins. Each truck cannot go over the maximum of 45 bins and 42000 pounds. I am trying to get the "ship per truck" columns to automatically tell how many bins to ship (with a max of 10 bins of each part) per truck going down the list of available bins to ship. I am having trouble getting it to stop skipping lines, or adding where the bins needed is already fulfilled on another truck. Like i said, i'm kind of a newb and the formula has gotten so big i cant trouble shoot it any more. Any help is very much appreciated.