I am trying to put together a calculation which tells me if a word is in a field it will return a 0 and if its not it returns a 1.
Field Name: Project: If the contents have the word Travel the result is a 0
Project:(Cedarburg Library) it returns a 1
Project:(Cedarburg Library Travel) it returns a 0
It could look like this as well
Project: (Cunningham) it returns a 1
Project: (Cunningham Travel) it returns a 0
Any help would be appreciated