Thread: Display Zero only in Selected Cells using a formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Display Zero only in Selected Cells using a formula
Maybe this would suffice:
=IF($A50="Public Injury",CityPanmureDepots!$G31,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"Steved" wrote:
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