View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default 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.