MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to hide "#DIV/0!"


Posted by Greg on October 23, 2001 4:41 AM

I have a simple formula in column C. It calculates a percentage using the data from columns A and B. If I have not yet entered data into A & B I get this #DIV/0!
result all the way down column C. How do I hide this "result"?

Thanks to all that reply.


Posted by Jerid on October 23, 2001 4:50 AM

Try this

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

Replace the formula A1/B1 with your formula.

Jerid

Posted by Greg on October 23, 2001 5:14 AM

YES YES!!! It works. thanks a lot.

Posted by Aladin Akyurek on October 23, 2001 5:34 AM

Jerid --

Why not

=IF(B1,A1/B1,"") [ or, maybe, =A1/MAX(1,B1) ]

instead of ISERROR that catches any type of error?

Regards,

Aladin

Posted by Don C on October 24, 2001 8:04 AM

Or this:

Posted by Don C on October 24, 2001 8:08 AM

Oops, hit return too soon

Or this:

=if(B1>0,A1/B1,"")
which would just check to be sure a value is in B1.