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)


"Brian" wrote in 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
...
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