I am trying to look for a set of characters in a cell. If the characters are found, enter "CB" in the cell and return a 0 (zero) if the characters are not found.

In a separate column, I entered the formula:

=IF(FIND("CACIWC",G4,1)>0,"CB",0)

With the above formula, if the characters are found it works... if they're not found in end up with #VALUE!

What am I doing wrong?