referencing cells that return blank results
 

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

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

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

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

Thank you both. Otto, after a bit of 'tweaking' the formula worked great!
Lee, thank you for responding, even though I caused some confusion with the
way I worded my question.

Cheers :) Sue

---------------------

"Otto Moehrbach" wrote:

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"
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"
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"

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