Search inside a cell

I am trying to return a Boolean value for if a cell has either a # or a @ in it.

I have the formula =if(isnumber(search("@",CELL))=TRUE,"Yes","No")

The CELL is what cell I am searching in. These possible cells could have numbers and letters in any combination. I just need to see if they have an @ or a # in them.