Thread: Formula returns "0"; How do I make it return nothing?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tony h
 
Posts: n/a
Default Formula returns "0"; How do I make it return nothing?

try

=IF('sheet1!A1'=0,"" , 'sheet1!A1')

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=533945

Reply With QuoteReply With Quote