Good morning I'm trying to do an IF formula to resolve the #DIV/0! error that i get in fields that are still waiting on data. this is my formula: =IF(SUM(C20/I20)=0,0,(C20/I20)) i appreciate your help.
=IF(I20=0,0,C20/I20) -- Gary''s Student - gsnu200761
=if(iserror(c20/d20),0,c20/d20) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo
That worked perfectly... thank you very much. Ma you both have a Merry Christmas and Happy New Year!