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