• 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.

nested if

N

nader assaleh

Member
dears
I have a problem, attached file can show the problem much clearer
eg.
if 31p is used the 31l,31r,32l and 32r Must not be used.
if any of 311,31r,32l or 32r is used the 31p Must not be used

if 31l,32l,33l and/or 31r,32r,33r are used then 31p and 32p
if 31p and 32p are used then 31l,32l,33l
31r,32r,33r are to be blocked and so on.
attached file will illustrate it clearly.
regrds
 

Attachments

  • Book11.xlsx
    14.1 KB · Views: 10
Hi
attached file show clearly that 31p overlpas with 31l,31r,32l,32r so if 31p is used then 31l,31r,32l,32r MUST be blocked,
32p overlaps with 32l,32r,33l,33r so if 32p is used then 32l,32r,33l,33r MUST be blocked. if 32L and/or 32r then 31p and 32p MUST be blocked and so on.
 

Attachments

  • Book11.xlsx
    13.7 KB · Views: 15
This is an interesting question. Is this for cargo loading? It might help if you explain the end use.

Note that this will require VBA and that your question topic is a little misleading. But I'm sure I can assist you with this.
 
I recently answered a similar question on a forum. Not quite the same, though.
This will be fairly simple to do...should have something for you soon.
 
Question: what will your input file look like? i.e. the first file you posted, or the second file, or something else? (The 2nd file is easier to code up).

Where will users enter data?
 
ok. Can you show me on the 2nd one the kind of things users will enter?

I need to see what they enter, and where they will enter it.
 
You must log in or register to reply here.
Back
Top