Is this proper syntax for a combined AND/OR If statement?

[Ulnarian]

I have a section of code that I can't seem to get working and I wondering if its just my syntax.

Here's the problem portion

Please Login or Register  to view this content.

My code doesn't seem to look at the (thisRow,11) value.

In general, is this the correct way to phrase a combined AND + OR statement?

Thanks!

[maclearyj]

Hi there. It Totally depends on what you are trying to do. I guess from the snippet you posted that you are trying to see if you have a'US' in column 11 and then check for one of a set of values in column 6 (the OR bit). If that is the case, enclose all your ors within a set of brackets. So the line would be elseif condition1 AND (condition2 OR condition3 OR condition4 etc).

[Ulnarian]

Hi there. It Totally depends on what you are trying to do. I guess from the snippet you posted that you are trying to see if you have a'US' in column 11 and then check for one of a set of values in column 6 (the OR bit). If that is the case, enclose all your ors within a set of brackets. So the line would be elseif condition1 AND (condition2 OR condition3 OR condition4 etc).

Perfect, this works, thanks!!

[maclearyj]

You're welcome. If you haven't already please click on the Add Reputation star underneath my post (or this one).

[Ulnarian]

You're welcome. If you haven't already please click on the Add Reputation star underneath my post (or this one).

Sorry, I didn't know about the reputation system. Done!

[jeffreybrown]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.