Thread: Replacing #DIV/0! With Just 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James McDowell
 
Posts: n/a
Default Replacing #DIV/0! With Just 0
I usually use the following for a formula

simple formula =a1/b1 can give you a number of errors. So I use
=if(iserror(a1/b1),0,a1/b1)

"Mike" wrote:

Is there a way to replace #DIV/0! error message with just 0?
Reply With QuoteReply With Quote