[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" 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!

[chicrocker21]

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!

[Mike H]

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!

[David Biddulph[_2_]]

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)
--
David Biddulph

"Mike H" wrote in message
...
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!

[Don]

another method

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

this will catch 0 and blanks

"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!

[Gord Dibben]

And mask any other error which may come along.


Gord Dibben MS Excel MVP

On Thu, 12 Jun 2008 08:04:00 -0700, Don wrote:

another method

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

this will catch 0 and blanks

"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!