(Msg. 1) Posted: Sun Aug 17, 2008 10:46 pm
Post subject: using CELL function Archived from groups: microsoft>public>excel>misc (more info?)
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.
(Msg. 2) Posted: Mon Aug 18, 2008 1:00 am
Post subject: Re: using CELL function [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Mon Aug 18, 2008 2:52 am
Post subject: Re: using CELL function [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Give this formula a try instead...
=IF(ISNUMBER(FIND("@",B10)),B10,0)
Rick
"ManhattanRebel" <ManhattanRebel RemoveThis @discussions.microsoft.com> wrote in message
news:6D9A2733-D155-4DAA-B88D-B62CC11628DF@microsoft.com...
> 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.
>
(Msg. 4) Posted: Mon Aug 18, 2008 3:02 am
Post subject: Re: using CELL function [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
try something like...............
=IF(LEFT(B10,1)="@",B10,0)
Greetings from New Zealand
"ManhattanRebel" <ManhattanRebel.RemoveThis@discussions.microsoft.com> wrote in message
news:6D9A2733-D155-4DAA-B88D-B62CC11628DF@microsoft.com...
> 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.
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office