How to truly hide an error?

Hi,

I use formulas that can come across errors such as divide by zero occasionally, it's just the nature of the data not being available on occasion.

Previously i have used conditional formatting to make the text white if there is an error. This is a very, ermm, dumb, way to do it. But it works. Kinda.

"Kinda" is the issue here. When iIwent to print my smart looking powerpoint presentation that made use of my excel tables, to my horror, the printer decided to ignore that the text was white on white formatting and just print it black, so these usgly errors are visible in my table!

Alright to cut the rant short and get to the point, is there a way to truly ignore these errors, including when transferring the data into powerpoint and when printing? (I assume theres an option when printing to not do this, but still it makes more sense to solve the root of the problem instead.) to either show a blank box, or a 0.

Thanks.

You need to put it in the formula:

PHP Code: 

IF(ISERROR(A1/2),"",A1/2) 


Thanks so much twiggy. Works exactly as intended, very simple, too!

Only complaint now, is that with my Excel 2003, it's quite a lot of effort to copy paste + amend the formula for every time it's required. But I'll cope, haha. (I am aware of Excels ability to autofill lots of cells that would allow me to do this very easily in some cases. Unfortuantely my tables are built with no sense of pattern so the autofill would not really help (There being no pattern can't be helped, either, again, just the nature of the data i am dealing with.))

Thanks again Twiggy.