zero error

T

tryn2learn

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.
 
M

Marcelo

=if(iserror(c20/d20),0,c20/d20)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"tryn2learn" escreveu:
 
T

tryn2learn

That worked perfectly... thank you very much.

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