Brittle
03-28-2006, 07:25 PM
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
03-29-2006, 04:38 AM
try this: http://support.microsoft.com/?kbid=154874
Tom
whitesco
03-29-2006, 07:31 AM
I've always handled that by prefacing my math with an if statement, something like =if (C1<>0, 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
03-29-2006, 01:24 PM
Hi Thanks.. I shall try it