Start Free Trial

asked on

Getting a blank in a cell that refers to another cell that is blank but has a formula in it.

I have a cell (say B1) that I want to put some text into, but only when another cell (cell A1) is blank. That cell (A1) has a formula in it (simply it says [='Drop-down data'!$C3], so it is just getting text copied in from cell C3 on another worksheet. If A1 is populated with this text then I want the selected text in the formula I have put into cell B1 to appear, but not otherwise. But I can't seem to do anything. I have tried all the IF(A1="","","text"), and tried ISBLANK, but to no avail.
Thoughts?

...but to no avail

What happens when you do this?

Saurabh Singh Teotia

Try this formula...

=IF(trim(A1)="","","text")

Open in new window

Also did you went into formulas-->Calculations option-->Automatic

As if its on Manual then the formulas won't work and calculate..

Saurabh...

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Hi both,
No, it's already on Automatic, and also your formula makes no difference. Tried that.
Richard

Saurabh Singh Teotia

Richard,

Can you upload your sample file here so that we can look what's really happening here...

Saurabh...

ASKER

Gowflow - that works!!
Many thanks - and also thanks to all.

ASKER

Quick, easy, good,

Welcome
gowflow