Thread: if any 3 of 5 cells have 0 then 0.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
  
Posts: 207
Default if any 3 of 5 cells have 0 then 0.
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