• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HELP how to limit cell entry not to go beyond what stated on a particular cell

CMCJC

New Member
=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
 
Maybe this?

=MIN(C6,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))

If that's not what you want, attach a workbook with some expected results mocked up.
 
hi Ali,
Unfortunately, still not working. i have attached document for your help.
its just a basic formula im trying to come up for quoting purposes in logistics. when the data matches max pallet capacity generated in E11 information come up correctly. however, if quantity goes beyond the max pallet capacity which in cell E2, it does not stay within the limit or it generates a random number.

thank you
 

Attachments

  • pallet template.xlsx
    11.7 KB · Views: 4
Back
Top