referencing cells that return blank results

[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

 

[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

 

[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]

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

 

[Suz]

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