Thread: Display Zero only in Selected Cells using a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
  
Posts: 519
Default Display Zero only in Selected Cells using a formula
Hello from Steved

Please using the bottom formula I would like the cell to display "0"

What is required please to acheive this

=IF($A50="Public Injury",SUM(CityPanmureDepots!$G31),0)

I Thankyou.



Reply With QuoteReply With Quote