View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default To leave a blank cell

Hello from Steved

With the below formula what is required please to have the cell blank as at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.