Contains and IsNull formulas - is "=true" necessary

You can also do just:

Contains([TESTFIELD], "Yes")

Which will work as well. As Adam said it defaults to true. So if TESTFIELD contains "yes" it will be true, if not it is false. You can test that with a formula checkbox. If you need to flip the conditions for whatever reason then you can include the True and False in there too.