View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joey_boy joey_boy is offline
external usenet poster
 
Posts: 2
Default Divide by 0 Help

=(SUM(E98:F98)+D98/2)/(I98-G98)

Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0
Error in any of the calculations. I am a bit of a novice.