Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jun 2008
    Location
    Baltimore, Maryland, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OR Expression Within AND / OR Expression (2003 / 2007)

    Good evening.

    Using what I have learned from the Lounge over the past few weeks, I have written an AND / OR formula that establishes two sets of conditions to command text to print. In it's original form, it is effective. (Thank you, Paul. I used a suggestion from you which proved to be tailor-made for this purpose.)

    However, I inserted an OR expression into the first conditions set, and the formula no longer works at all.

    Can anyone tell me how w to incorporate the additional OR expression into the exiting AND expression? Please see attached document, containing examples with delineated expressions.

    Thank you.

    Kevin
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OR Expression Within AND / OR Expression (2003 / 2007)

    Does the modified Sample2 in the attached version do what you want.
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Jun 2008
    Location
    Baltimore, Maryland, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OR Expression Within AND / OR Expression (2003 / 2007)

    No. Both Sample 2 and Sample 3 print nothing, regardless of the conditions. It is as though the addition of the OR expression in Pink some how "disconnects" everything. To troubleshoot, I replace the OR expression ion question with a simpler IF expression, like all of the others, and the formula worked. So it seems as though the problem involves extra or missing characters in the OR expression. I have examined each of them (in Sample 2 and Sample 3), and they seem to be correct. But perhaps being inserted into other expressions requires some augmentation to an OR expression of that type.

    Kevin

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OR Expression Within AND / OR Expression (2003 / 2007)

    There is no Sample 3 in the document that I attached (I deleted it). <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    Star Lounger
    Join Date
    Jun 2008
    Location
    Baltimore, Maryland, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OR Expression Within AND / OR Expression (2003 / 2007)

    I'm sorry, Hans. I didn't realize that you had included an attachment. (I've been up all night working on this stuff. I suppose my vision is fading along with my concentration.)

    Yes, your revision was indeed effective. I think I actually understand why your solution worked, this time. I apparently had too many "IF"s in there.

    Thank you, again, for doing in a few minutes what I could not in a few hours. Very much appreciated.

    Kevin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •