Thread: getting rid of #DIC/0!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
  
Posts: 449
Default getting rid of #DIC/0!
=IF(B1=0;"";A1/B1)
or -excel 12 only:
=IFERROR(A1/B1,"")


HTH. Best wishes Harald


"James" wrote in message
...
is there something you can add to a formula so if it equals #DIV/0! the
cell
will remain empty or blank?

Reply With QuoteReply With Quote