=IF(E2 <= E11, MIN(C6, CEILING(E2 / E9, 1) * C2 + D6), C6) + IF(E2 > E11, MIN(C6, CEILING((E2 - E11) / E9, 1) * C2 + D6), 0)
im using this formula to figure pallet height for specific products. everything seems to work when information matches max pallet capacity however if you beyond that limit, the pallet height comes up with higher number that has been set in cell C6.
how can i prevent this from happening and maintaining max pallet capacity.
![1730851757857.png 1730851757857.png](https://chandoo.org/forum/data/attachments/89/89150-24d2eda5e4536b49b0aa09b64d66b452.jpg)
im using this formula to figure pallet height for specific products. everything seems to work when information matches max pallet capacity however if you beyond that limit, the pallet height comes up with higher number that has been set in cell C6.
how can i prevent this from happening and maintaining max pallet capacity.
![1730851757857.png 1730851757857.png](https://chandoo.org/forum/data/attachments/89/89150-24d2eda5e4536b49b0aa09b64d66b452.jpg)