Hello,

Can you please help me with the following?

My company purchases a certain product by cases. If we purchase 76 cases of the product in an order, that equates to 1 pallet and we get a certain discount for it. If we purchase 38 cases of the product in an order, that equates to 1/2 a pallet and we get a certain discount for it.

So the report that I generate contains a column showing how many cases were bought per order - please see below:

38cs
76cs
152cs
224cs
228cs
55cs
67cs
72cs

I know 152 cs (cases) equals 2 pallets so we get a certain discount. Because the 152 cases are equivalent to 2 whole pallets that is easy to calculate our discount. However, if there were 224 cases, that is equal to 2.95 pallets. We don't get a discount for the .95 pallets because that is not a full 1 whole pallet. But we do get the discount for the 2 pallets within the 224 cases purchased.

Ultimately my question is, How do i do an If statement that divides by 76 cases or 38 cases and rounds DOWN to the nearest WHOLE number of pallets??

Sorry for being long and windy, but thank you for your help!