Thread: Format for a cell with a formula in it but I don't want the 0 to c
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Format for a cell with a formula in it but I don't want the 0 to c
Hi,

Something like this

=IF(Sheet2!A1="","",Sheet2!A1)

Mike

"texansgal" wrote:

I am trying to format at worksheet and use formula's to reference a different
page. What format can I use so that when there is no information entered in
the referenced cell it doesn't show a 0?


Reply With QuoteReply With Quote