Addition to earlier sum if question

Stclements1

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

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top