EZ IIF( Q (v2KSR1)

Topic

New Reply

I searched hi and lo for a different route but with no luck. Consider this IIF( statement:
IIf([wow]=”a” Or [wow]=”b” Or [wow]=”c”,”abc”,”xyz”)
Is there a way to recreate this statement without repeating the “[wow]=” ?
I know this won’t work:
IIf([wow]=”a” Or “b” Or “c”,”abc”,”xyz”) but is there a different approach?
Thanks!!

Reply | Quote

Replies

Try using IN keyword. Example:

IIf([Wow] In (“A”,”B”,”C”),”ABC”,”XYZ”)

HTH

Reply | Quote

Outstanding Mark! Thanks a bunch…it worked perfectly!! Have a great weekend.

Reply | Quote