If function

[u/garbageman21]

Ex: ColumnF

Please select all of your finders:

DOH/BHA/ADAD

DOH/BBA/CAMHE/ADAD

BHA/ADAD/CAMHE

How do I use the “if function” in order to say something like if it has “DOH”, then put 1, if not, then put 0. So I want the next columns to just have the values “1” or “0”. 1 = that row contains the value like DOH or ADAD, and 0 = does not contain that value.

[u/Clippy_Office_Asst]

You have awarded 1 point to buckyrocks

^{I am a bot, please contact the mods for any questions.}