View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PATTO PATTO is offline
external usenet poster
 
Posts: 1
Default #DIV/0! to read as 0

Is there a simple formula for displaying "0" as a result, not "#DIV/0!", when
cells are intentionally left blank or contain "0" as a divisor ?
If so, how is it applied with a formula already in the cell?
Hope someone's got the answer..
thanks