Hello,
When I use Contains in an IF statement do I need to include =-1 to ensure I only get entries where the statement is true? I know that if I'm looking for anything that is false I would need =0. However, I don't know if the =-1 is just overkill or if it is really needed. Would the 2 examples below yield the same results?
Here is an example of what I'm talking about
IF Contains("ABC123", [letters]) = -1 THEN "Awesome" ELSE "Shucks" ENDIF
IF Contains("ABC123", [letters]) THEN "Awesome" ELSE "Shucks" ENDIF
Solved! Go to Solution.