Try =if(iserror(formula),0,formula)
************
Anne Troy
www.OfficeArticles.com

"Dave" wrote in message
...
What is the formula that brings back a zero for an empty cell instead of
0 0 #DIV/0!