using CELL function

[ManhattanRebel]

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.

 

[Héctor Miguel]

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.

 

[Bill Kuunders]

try something like...............

=IF(LEFT(B10,1)="@",B10,0)

Greetings from New Zealand

 

[Rick Rothstein \(MVP - VB\)]

Give this formula a try instead...

=IF(ISNUMBER(FIND("@",B10)),B10,0)

Rick