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

-----Original Message-----
Perfect!
But what is LEN?

Thanks bob

"Bob Phillips" wrote:

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

--

HTH

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


"Brian" wrote in
message
news:25542EC7-BF35-40B3-BCA2-
...
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




.