Lee
Of course the cell is not empty. It has a formula in it. The formula
is written to return a blank cell in that case, not an empty cell. Otto
"lee.christopher" wrote in message
...
This is the standard answer to the question, but the text string "" is
apparantly not quite the same thing as the property 'Empty' or 'Blank',
though I don't know exactly what the difference is.

If your formula writes "" to a cell, the cell is not absolutely blank. As
far as I'm aware there's no formula that can make a cell blank.

It's an issue for those who know the older mainframe systems such as RS/1,
because with Excel, you can't predict exactly how your formula will
behave. Since the question has been raised about several successive
versions of Excel, there must be some fundamental limitation with this
software. With VBA 'UsedRange' poses similar questions.

Regards


"Otto Moehrbach" a écrit dans le message de news:
...
Say that you want results in B1 only if A1 is not blank. In B1 put your
formula lake this:
=If(A1="","",your formula)
HTh Otto
"Suz" wrote in message
...
Hi gang:

I need a formula to return results ONLY if the results of the formula in
an
adjacent cell are not blank.

I hope this is enough information for someone to help.

Much appreciated if so!

Sue