Excel - zero error

Asked By tryn2lear on 21-Dec-07 12:20 PM
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.

GarysStuden replied on 21-Dec-07 12:27 PM
Gary''s Student - gsnu200761
Marcel replied on 21-Dec-07 12:28 PM

regards from Brazil
Thanks in advance for your feedback.
tryn2lear replied on 21-Dec-07 02:41 PM
That worked perfectly... thank you very much.

Ma you both have a Merry Christmas and Happy New Year!