In Column A, lets say I have a range of names.
In Column B, I want to use an IF statement to identify IF the corresponding cell in A has the name Bob or Jill.

This is what I thought it should be:

IF(A1={"Bob", "Jill"}, 0,1)

So when I use the fill handle for the entire column, everywhere with a "Bob" or a "Jill" should be a 0. Instead, it is only finding the "Bob" and not the "Jill". Am I missing some syntax issue here? Thanks if anyone can help.