This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Does not contain

Posted on 10-23-2020 03:46 PM
Tom_automated
New Member
Reply posted on --/--/---- --:-- AM

Is there an opposite for CONTAINS([City], “Capitol”)? I need something that says does not contain Capitol, does not contain Town, does not contain, County

0 2 285
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Chris_Jeal
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

Try:

NOT(CONTAINS([CITY],“Capitol”))

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

For reference:


Top Labels in this Space