return blank cell if condition met

  • Thread starter Thread starter Simon Webb
  • Start date Start date
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
 
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
 
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
Click to expand...

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.
 
Back
Top