View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Curtis Dave Curtis is offline
external usenet poster
 
Posts: 100
Default Divide by Zero Error

Hi,

You can try embedding your formula in an IF function with ISERROR, to return
something else instead of the error.

=IF(ISERROR(your formula),"something else", your formula))

Dave

url:http://www.ureader.com/msg/104234844.aspx