Validating Outlook form with "OR" and "AND"

[vincetaylor]

I need to validate an outlook form using an an "OR" statement.
When I validate without "OR", the formula below works. The form is not sent and the appropriate error message appears.

([Number] <>"1" )

But when I try to make it a compound validation by using "OR", the validation does not work.

([Number] <>"1" ) OR ([Number] <>"2" )

The form is sent and the appropriate validation message is not displayed.

I have tried to use the symbols "||" instead of "OR". That doesn't work at all. I get an Outlook generated error message that has nothing to do with the issue

My end goal is to use "OR" and "AND" in the same formula so I would also appreciate any help with "AND"

The end formula should look like this:

([Number] <>"1" ) OR ([Number] <>"2" ) AND [Letter] <> "A"

I would appreciate help with one or both issues.

 

[Diane Poremsky]

This should work -
([Number] >"2" ) AND [Letter] <> "A"