Thread: removing unneeded information
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Cal Cal is offline
external usenet poster
  
Posts: 7
Default removing unneeded information
In cell AF4 iI have the following formula; =SUM(C4,G4,K4,O4,S4,W4,AA4) with
no data in those cells, cell AF4 shows 0.00. how do I get the cell blank if
the value is 0.00?
Reply With QuoteReply With Quote