View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default how to remove #DIV/0!

Another way:

=IF(B1=0,0,A1/B1)

Hope this helps.

Pete