Compound IF, OR, AND in Outlook form

Status
Not open for further replies.
V

vincetaylor

Senior Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
I have a formula that checks for two conditions. Both conditions 1 and 2 must be met. If the condition is met, an error message is displayed

1. Rank is set to "High" or "Medium"
AND
2. Disposition is blank.

I am able to get condition 1 and 2 to work separately as follows:

1. IIF( Rank] ="High" OR [Rank]="Medium" ,"Invalid Entry","")
2. len([Disposition])>0

However and I try to combine the "OR" with the "AND", nothing works. I have tried to combine the OR with the AND using several techniques such as the following:

IIF( ( [Rank] ="High" OR [Rank]="Medium") AND (len([Disposition])>0) ,"Invalid Entry","")

Any help will be highly appreciated
 
Did you try NULL instead of > 0? If there was no value in the field, it could be null - but if it had a value and the value removed, it might be 0.

If you test it with the IIF statement and text in the Disposition field, does it throw up the message?
 
See if this works - IIf([Rank]="High" Or [Rank]="Medium",IIf(NOT [Disposition] ,"Invalid Entry",""),"") - or not - its failing if there is something in Disposition but ignores Rank for me.

or try the two that worked for you - in nested iif
IIF( [Rank] ="High" OR [Rank]="Medium" ,IIF( len([Disposition])>0 ,"Invalid Entry","")","")
 
Hi Diane Thanks for your help.
I have tried your proposals above and various variations of them.

The first one allows the form to be sent even when [Rank]= "High" or [Rank] = "Medium"

The second results in a syntax error while developing the form as follows:
"Error in validation formula -- String constant is not valid
 
Status
Not open for further replies.
< VBA to Auto Insert Date and Time in the signature | WshShell.Popup does't timeout >
Similar threads
Thread starter Title Forum Replies Date
G Outlook 2007 compound (OR) instant search break down Using Outlook 14
G Outlook 2021 (New) doesn't respect default browser Using Outlook 1
B Outlook or iPhone turning tabs into spaces in Outlook Notes Using Outlook 1
P newly installed Office 365 includes OLD Outlook Using Outlook 6
R Outlook ribbon menu default? Using Outlook 7
H Spam email in Gmail not visible in Outlook Using Outlook 3
J How to transfer Win 10 Outlook to new Windows 11 pc? Using Outlook 9
J Renegade spam URL line displayed in old local Outlook 365 email title Using Outlook 3
G Reduce whitespace in Outlook desktop Contact Cards display Using Outlook 3
C Outlook classic via 365 Using Outlook 2
Dr. Demento Analogous Outlook code to read info into an array (or collection or whatever) Outlook VBA and Custom Forms 7
S Repair Outlook Using Outlook 8
V Outlook Form ListBox is not editable Outlook VBA and Custom Forms 2
F Outlook's contacts Using Outlook 1
D Outlook 2003 stopped dead Using Outlook 2
G Cannot receive emails from gmail account in Outlook 365 Using Outlook 1
E "Cannot display the folder. MS Outlook cannot access the specified file location" Using Outlook 8
P Outlook 2016 Working Offline Using Outlook 2
Rupert Dragwater Cannot reestablish gmail (email address) account in Outlook 365 Using Outlook 11
O Outlook 365 synchronisieren Exchange Server Administration 1
kburrows Outlook Classic - JPG files are corrupted when opened or saved Using Outlook 3
F Sync Outlook Calendar Using Outlook 0
G Change default font size in sticky notes - Outlook Desktop 2021 Using Outlook 2
C VBA in "New Outlook?" Using Outlook 0
D New Outlook with Business Basic Plans Using Outlook 0
D Outlook 2021 not working with Outlook 2003 installed Using Outlook 5
D Outlook 2003 stopped working - get they dialog box asking for username & Password Using Outlook 2
T Outlook 2021 hangs in close on taskbar occasionally Using Outlook 1
M Duplicate removal feature in Outlook 2021 is faulty Using Outlook 2
D.Moore Outlook COM addins source folder Using Outlook 12
P Removing Outlook 365 Account from Send/Receive Using Outlook 3
kburrows Outlook Automatically Merging Contacts Using Outlook 2
A Outlook 2016 Outlook 2016 vs. New Outlook Using Outlook 4
D Outlook Desktop App Email Software Using Outlook 0
efire9207 VBA Outlook Contacts Outlook VBA and Custom Forms 6
M Outlook not logging in to server Using Outlook 0
J Outlook macro to run before email is being send Outlook VBA and Custom Forms 3
R Outlook 2021 change view Using Outlook 2
K Outlook font corrupted in some point sizes, resets on close/open Using Outlook 2
J Is the Windows Outlook Tasks module really going to be gone? Using Outlook 6
F Outlook 2010 and Hotmail Using Outlook 1
A Outlook 2021 needs 'enter' for people search Using Outlook 2
HarvMan Outlook 365 Inbox Font Using Outlook 8
Retired Geek Outlook on MAC delete duplicate Sent emails Using Outlook 0
S New Outlook - IMAP ISSUES and support for addins? Using Outlook 1
C outlook.com fonts Using Outlook 2
R Outlook with several IMAP accounts generating folders with 1111 suffix Using Outlook 0
D Send email from Outlook Alias using Mac? Using Outlook 0
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 2
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 0

Similar threads

Back
Top