Empty cell instead of 0
 

Hi all,
In a cell, I make a copy of another cell with the formulae "=A1".
My problem is that if A1 is empty, the formulae display "0" instead of
nothing!
How can I change that?

Thank you.

Empty cell instead of 0
 

=IF(A1="","",A1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Zorro" wrote in message
...
Hi all,
In a cell, I make a copy of another cell with the formulae "=A1".
My problem is that if A1 is empty, the formulae display "0" instead of
nothing!
How can I change that?

Thank you.

Empty cell instead of 0
 

Hi Zorro

In case you just want to hide the 0's from view/ print, select the
cell(s) containing formulas and set conditional formatting for the
cells to font colour similar to the background e.g. white.

Format Menu Conditional formatting Condition 1 (Cell value is
equal to 0) format

and then going to Font tab and choosing font colour as white or
whatever is your back ground.

However, the 0's are still very much there.

DIYKID



Zorro wrote:
Hi all,
In a cell, I make a copy of another cell with the formulae "=A1".
My problem is that if A1 is empty, the formulae display "0" instead of
nothing!
How can I change that?

Thank you.

Empty cell instead of 0
 

Not sure if this will address your real issue, but you could use conditional
formatting to make nothing appear if cell equals zero.

"Zorro" wrote:

Hi all,
In a cell, I make a copy of another cell with the formulae "=A1".
My problem is that if A1 is empty, the formulae display "0" instead of
nothing!
How can I change that?

Thank you.