Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 172
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi, Can someone help with the below formula? Thanks
<tbody>
</tbody>
If less than 42 carton = 1 and divide greater than 42 carton, divide by 42 to get number of pallets required. | ||||||||
Cartons Per Pallet | 42 | |||||||
Less than 42 | 1 | |||||||
Customer | No. Ctn | No. Pallets | Answer | |||||
Customer 1 | 8 | 1 | ||||||
Customer 2 | 48 | 1.14 | ||||||
Customer 3 | 16 | 1 | ||||||
Customer 4 | 13 | 1 | ||||||
<tbody>
</tbody>