isblank function

[Guest]

Hello,

In cell A2 i have the following: =if(isblank(A3),A1,"")

Problem is that A3 has a formula within it and at times appears blank
because it contains a vlookup function that has not returned data yet because
its reference cell may is blank. So I thought that A3 could be considered
blank until such time that the reference cell activates the vlookup and
therefore data in cell A3.
What can be done to the above formula so that i get the same affect.

Thank You
Brian

 

[Bob Phillips]

=IF(LEN(A3)=0,A1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Perfect!
But what is LEN?

Thanks bob

=IF(LEN(A3)=0,A1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Brian,

It tests the length of the value in the cell, So, if it is blank, or if
there is a value that resolves to "", it will return 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Biff]

Hi!

LEN() is the function that returns the length of a string
in a cell.

=LEN(1234) = 4
=LEN( 1234) = 5

A cell is not blank if it contains a formula even if the
formula itself returns "". The "" is actually a zero
length text string.

=IF(LEN(A3)=0,A1,"")

So the formula is testing the length of cell A3.

Biff

 

[Guest]

Thank You

Brian,

It tests the length of the value in the cell, So, if it is blank, or if
there is a value that resolves to "", it will return 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thank You

Hi!

LEN() is the function that returns the length of a string
in a cell.

=LEN(1234) = 4
=LEN( 1234) = 5

A cell is not blank if it contains a formula even if the
formula itself returns "". The "" is actually a zero
length text string.

=IF(LEN(A3)=0,A1,"")

So the formula is testing the length of cell A3.

Biff

 

[Harlan Grove]

It tests the length of the value in the cell, So, if it is blank, or if
there is a value that resolves to "", it will return 0.

Give 'em a fish, and they'll ask for chips. Teach 'em to fish, and they can
go into business for themselves. Or perhaps using online help is only meant
for us archaic types.

 

[Bob Phillips]

You know that's the truth Harlan, it's the modern world

BTW the phrase we (I?) use is give a mouse a cookie, and he'll ask for a
glass of milk ...

--

HTH

RP
(remove nothere from the email address if mailing direct)