Strange behavior

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01C88562.E7DE8BB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

A B C D
as tr cf x
er wr =20
sg rt yu x =20
sd ff x
df qw cv x
In the above array, columns A,B, & C are formulas. Theey represent a =
first name, last name and email address, respectively. The formula for =
column D is =3Dif(C2<>"","x",""). I've replicated it down the column.=20

When note that line 3 works correctly, but line 5 does not. Nor does the =
formula work in any following rows.=20

I tried the same thing, programming in VB, with similar results. This =
must be a setup problem, but I can't figure it out.
I'm using Office 2007 SP1, and Vista Home Professional.

Any suggestions would be appreciated...

Jim
------=_NextPart_000_0006_01C88562.E7DE8BB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16609" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>A    B    =

C    D</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>as    =
tr   =20
cf   x</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>er   =20
wr           =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>sg   =20
rt   yu   x    =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>sd   =20
ff          x</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>df    qw   =
cv  =20
x</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>In the above array, columns A,B, & =
C are=20
formulas. Theey represent a first name, last name and email address,=20
respectively. The formula for column D is =3Dif(C2<>"","x",""). =
I've=20
replicated it down the column. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>When note that line 3 works correctly, =
but line 5=20
does not. Nor does the formula work in any following=20
rows. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I tried the same thing, programming in =
VB, with=20
similar results. This must be a setup problem, but I can't figure it=20
out.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I'm using Office 2007 SP1,  and =
Vista Home=20
Professional.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestions would be=20
appreciated...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV></BODY></HTML>

------=_NextPart_000_0006_01C88562.E7DE8BB0--

pub
Fri Mar 14 02:46:56 CDT 2008

"Jim Berglund" <jazzzbo@shaw.ca> wrote in
news:D3322DFC-236E-4097-A470-C8E63391C674@microsoft.com:

> A B C D
> as tr cf x
> er wr
> sg rt yu x
> sd ff x
> df qw cv x
> In the above array, columns A,B, & C are formulas. Theey represent a
> first name, last name and email address, respectively. The formula for
> column D is =if(C2<>"","x",""). I've replicated it down the column.
>
> When note that line 3 works correctly, but line 5 does not. Nor does
> the formula work in any following rows.
>
> I tried the same thing, programming in VB, with similar results. This
> must be a setup problem, but I can't figure it out. I'm using Office
> 2007 SP1, and Vista Home Professional.
>
> Any suggestions would be appreciated...
>
> Jim

have you tried
copy the blank in c2 and paste in c4? jsut to see if theres any difference?

try this real quick
=countblank(c2)
should give you a 1

=countblank(c4)
should also give you a 1

if it does, then change your formula to
=if(countblank(a1)=0,"x","")

or

since c is a email address try using the if to look at the length
=if(len(a1)>3,"x","")

*alan*
Fri Mar 14 21:50:25 CDT 2008

"Jim Berglund" <jazzzbo@shaw.ca> wrote in message
news:D3322DFC-236E-4097-A470-C8E63391C674@microsoft.com...
A B C D
as tr cf x
er wr
sg rt yu x
sd ff x
df qw cv x
In the above array, columns A,B, & C are formulas. Theey represent a first
name, last name and email address, respectively. The formula for column D is
=if(C2<>"","x",""). I've replicated it down the column.

When note that line 3 works correctly, but line 5 does not. Nor does the
formula work in any following rows.

I tried the same thing, programming in VB, with similar results. This must
be a setup problem, but I can't figure it out.
I'm using Office 2007 SP1, and Vista Home Professional.

Any suggestions would be appreciated...

Jim
-----------------------------------------------------------------------------
That's strange behavior indeed, but then again I'm using XL2003. Assuming
that the first row is headers (i.e. first name, last name, email address), I
attempted to replicate your results and your formula =IF(C2<>"","x","")
placed in D2 worked perfectly all the way down, producing an x whenever the
email address was present and a blank if not.
Another formula =IF(COUNTBLANK(C2)=0,"x","") also placed in D2 produced x's
as well to indicate presence of email address in column C. Very strange.
What bothered me though was that you'd said that the data in columns A,B,
and C are *formulas* and that they *represent" first name, last name, and
email address. If they are, in fact, formulas themselves and not actual
data, perhaps that's the root of your problem . . .
--
alan

Strange behavior

Re: Strange behavior by pub

Re: Strange behavior by alan

Strange behavior

Re: Strange behavior by pub

Re: Strange behavior by *alan*

Re: Strange behavior by alan