Excel format #DIV/0! to blank

[Brittle]

Hello, does anyone know how to in excel format cells that have #DIV/0! to a blank without using the ISNA command? Thank you

 

[Tom R]

try this: http://support.microsoft.com/?kbid=154874

Tom

 

[whitesco]

I've always handled that by prefacing my math with an if statement, something like =if (C10, D1/C1,0), to check to see if I was actually trying to divide by zero. That may or may not be feasible depending upon how you have your function nested, but I'm always a little leary of just globally hiding errors.

 

[Brittle]

Reply

Hi Thanks.. I shall try it