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
=IF(I20=0,0,C20/I20)
--
Gary''s Student - gsnu200761
Marcel replied on 21-Dec-07 12:28 PM
=if(iserror(c20/d20),0,c20/d20)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
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!