Stclements1
Board Regular
- Joined
- Sep 15, 2018
- Messages
- 158
- Office Version
- 365
- Platform
- Windows
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
=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