Thread: if any 3 of 5 cells have 0 then 0.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
  
Posts: 2,345
Default if any 3 of 5 cells have 0 then 0.
Do empty cells count as zero? If so then:

=IF(SUM((A4=0),(C4=0),(E4=0),(G4=0),(I4=0))2,0,"" )

If you want to exclude counting empty cells as zeros then:

=IF(SUM((A4=0)*(A4<""),(C4=0)*(C4<""),(E4=0)*(E4 <""),(G4=0)*(G4<""),(I4=0)*(I4<""))2,0,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Gaurav" wrote in message
...
What can be the shortest formula for this?

If any 3 of 5 non adjacent cells have 0 then 0.

Thanks




Reply With QuoteReply With Quote