return blank cell if condition met

[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

 

[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

 

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