View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Get rid of DIV/0 error message

=IF(Iserror(YourCellreference),0,(YourCellreferenc e))
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Jeff" wrote:

Is there a command to return a value of 0 instead of DIV/0 error message?

Thanks!!
--
Jeff