View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Replacing #DIV/0! With Just 0

"Mike" wrote:
Is there a way to replace #DIV/0! error message
with just 0?


Several ways. Among them:

=IF(denominator = 0, 0, expression)

=IF(ISERROR(expression), 0, expression)

=IF(ISERR(expression), 0, expression)

Use Help to see the difference between ISERROR()
and ISERR().