M mugman17 Registered User. Local time Today, 02:04 Joined Nov 17, 2000 Messages 110 May 4, 2006 #1 Can you use an OR in an IIF statement? For instance: IIf (Location = "27" or "18", TotalMgt, TotalMgt2). It doesn't appear to work whatever I try.
Can you use an OR in an IIF statement? For instance: IIf (Location = "27" or "18", TotalMgt, TotalMgt2). It doesn't appear to work whatever I try.
pbaldy Wino Moderator Staff member Local time Yesterday, 18:04 Joined Aug 30, 2003 Messages 36,272 May 4, 2006 #2 Try IIf (Location = "27" or Location = "18", TotalMgt, TotalMgt2)