Thread: How to show zero for #DIV/0!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default How to show zero for #DIV/0!
=IF(ISERR(YourFormula),0,YourFormula)


Vaya con Dios,
Chuck, CABGx3



"Brett Romero" wrote in message
...
Is there a way to replace #DIV/0! with a zero?

Thanks,
Brett




Reply With QuoteReply With Quote