If Contains and Equals Then Statement

[NicoleMA]

So I am horrible with If/Then Statements. I am trying to make a new column (vstring) that flags rows that need to be looked at based on what is in two columns.

The Top ZIP Sales ADI column is a vstring and the info in that column will look like this: Palm Springs, CA - 186, Los Angeles, CA - 812, etc.

The Percent of Total Circ by Market column is a double and would read like this: 1 or .022 etc

Here is what I came up with:

IF ([Top ZIP Sales ADI] contains "812") && ([Percent of Total Circ by Market] = 1) THEN "Ok" ELSE "Check" ENDIF

[MarqueeCrew · Accepted solution]

IF
Contains([Top ZIP Sales ADI],"812") &&
[Percent of Total Circ by Market] == 1
THEN "Ok"
ELSE "Check"
ENDIF

pretty close @NicoleMA

[NicoleMA]

It works! Thanks!