how to hide #DIV/0!

[chicrocker21]

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!

 

[Mike H]

Maybe

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

Mike

 

[chicrocker21]

thanks, it really help a lot!!!

Maybe

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

Mike

 

[Mike H]

Your welcome

thanks, it really help a lot!!!

 

[David Biddulph]

Or, if you want to flag the divide error if you genuinely have a zero in D9,
but leave the result blank if D9 is empty, try
=IF(D9="","",D8/D9)

 

[Don]

another method

=if(iserror(d8/d9),0,d8/d9)

this will catch 0 and blanks

 

[Gord Dibben]

And mask any other error which may come along.


Gord Dibben MS Excel MVP