3 Replies Latest reply on Jul 19, 2016 7:04 AM by Peter Seok

    If Statements with Wildcards

    Peter Seok

      Hi Everyone,


      I have a question on using if statements with wildcards.  I have a code that's alpha numeric, and the last 3 digits are always a specific 3 digit number.  I'd like to exclude anything that's in the 800 - 899, and 700 - 799 range, and I figure it should look something like this:


      IF RIGHT([Code],3)=8** THEN "Exclude" ELSEIF RIGHT([Code],3)=7** THEN "Exclude" ELSE "Include" END


      Doesn't seem to be working, any help would be greatly appreciated, thanks in advance!