Thread: Avoid #div/0!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HARSH BAHAL HARSH BAHAL is offline
external usenet poster
 
Posts: 14
Default Avoid #div/0!

Hi !

I want enter a sumproduct formula involving three ranges. However if any of
the range does not have a value the formula returns a #div/0! value. I want
to avoid that. Pl help.