View Single Post
  #10   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.

Thanks a ton everyone.

"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