Does anyone know why this always returns a "0" for the answer?:

=IF(CELL("contents", B10) = "@", +B10,0)

Some of the cells in column B have email addresses in them, some don't. I
am trying to capture the email addresses or return a value of "0", but only
"0" is returned no matter what.

Thanks.