help with excel ...

[Dr. Doctor]

New to group but here is my problem.
is their a way for a cell to read 0 when the it shows #DIV/0! [ not ethe
formual in that cel is c2/c3 but c2 & c3 to start with are valued at 0]
the formula I have works as long as numbers are inputed but I have to make
this genaric so when 1st used all cells read 0.

Thanks in advance

 

[Martin]

Try

=if(C3=0,0,C2/C3)

 

[Randall Roberts]

=IF(ISERROR(c2/c3),0,c2/c3

this should work for you)

 

[Dr. Doctor]

thanks for the help it worked perfectly