What is the formula that brings back a zero for an empty cell instead of 0 0 #DIV/0!
D Dave Sep 15, 2005 #1 What is the formula that brings back a zero for an empty cell instead of 0 0 #DIV/0!
A Anne Troy Sep 15, 2005 #2 Try =if(iserror(formula),0,formula) ************ Anne Troy www.OfficeArticles.com