return blank cell if condition met

S

Simon Webb

Hi

I am using IF command to automate a cells contents IF a condition in another
cell is TRUE, but how can I leave the cell empty if the condition is false?
IF a1 is >1 then a7 = a6+1 but if a1 is empty, I wish a7 to be empty. My
formula works but only if I display something in cell a7 if FALSE ie 0. How
can I display nothing?

Thanks enquirer
 
P

Pete_UK

Put this in A7:

=IF(A1>1,A6+1,"")

A7 will not be truly blank or empty, because it contains a formula,
but at least it will look empty.

Hope this helps.

Pete
 
A

Anand

Put this in A7:

=IF(A1>1,A6+1,"")

A7 will not be truly blank or empty, because it contains a formula,
but at least it will look empty.

Hope this helps.

Pete

Pete's solution will work perfectly fine. In case you want the cell to
be truly blank you can use paste special. Copy the entire column and
use Paste Special > Values. That will make the cells truly blank or a
value and remove the formula too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top