Hi there people im trying to do a vehicle routing problem on excel using evolver. I have been given a set of data with demands(number of cells 33) and I can only use 5 trucks that can only fit a max of 100. What im trying to do is tell excel that once reached a 100 it has to move on to the 2 truck and so on till 5. I have been told that I could use the IF function incoporated with the sum function. If anyone can help would be much appreciated?