View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default how to hide #DIV/0!

Your welcome


"chicrocker21" wrote:

thanks, it really help a lot!!!

"Mike H" wrote:

Maybe

=IF(D9<0,D8/D9,"")

Mike

"chicrocker21" wrote:

im having a problem with my formula here..my formula is d8/d9, but there is
no values yet for those cells and #DIV/0! appears,but i want the worksheet to
look clean..how can i hide #DIV/0! but the formula remains. thanks!