Thread: Return a blank cell instead of a zero value for two linked sheets.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt Matt is offline
external usenet poster
  
Posts: 516
Default Return a blank cell instead of a zero value for two linked sheets.
I have a producion summary linked to individual invoices. If the production
summary has no orders, how can I alter the linked cell to return a blank
rather than a zero in the individual orders?
Currently the value in the cell is ='SPOON ORDERSHEET'!I11

Thanks for your help
Reply With QuoteReply With Quote