hi, !

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...

AFAIK, the argument "contents" in CELL w-f is the same as referring to the "ref" itself
cell("contents",b10) = =b10

try with: =if(countif(b10,"*@*"),b10,0)

hth,
hector.