Thread: #div/0!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default #div/0!
Test for zero

=IF(B1=0,"",A1/B1)

Mike

"Dave" wrote:

How can you suppress the #DIV/0! error
Reply With QuoteReply With Quote