Addition to earlier sum if question

[Stclements1]

I have established that writing multoiple if functions such as below I can evaluate the costs of each item. I do think that there must be a simpler solution to my earlier questio (Sum if) and secondly if the quantity is less than the numbers laid out i;e multiples of 720 it returns false.

=IF(C8=720,'Full Cost'!C28,IF(C8=1440,'Full Cost'!D28,IF(C8=2160,'Full Cost'!E28,IF(C8=2880,'Full Cost'!F28,IF(C8=3600,'Full Cost'!G28))))) ETC TO L28

What i need in cell c8 is an mround function that automatically evaluates the amount of pallets required so if one pallet carries 720 items but I am shipping 1000 items it will automatically round up to the item value of two pallets i.e 1440 items and so on so I need it to always round up to the nearest multiple of 720

 

[arthurbr]

Perhaps =index($C$28:$L$28,ceiling(C8/720,1))