using CELL function

  • Thread starter Thread starter ManhattanRebel
  • Start date Start date
M

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.
 
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...
Click to expand...

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.
 
try something like...............

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

Greetings from New Zealand
 
Give this formula a try instead...

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

Rick
 
Back
Top