How Do You Hide a #DIVO! Return in a cell

[rpalmer4]

Ok, what is the formula to return a blank cell vs. a #DIVO! ? My formula
currently is =1-(C15/G15) however when C15 is 0 my return is #DIVO! I would
like for the cell to remain blank if the c15 cell is 0.

 

[Dave Peterson]

One way:

=if(g15=0,"",1-(C15/G15))

I think the problem is with G15--not C15.

 

[Ron Coderre]

Try this:
=IF(N(G15)=0,"",1-(C15/G15))

Does that help?

••••••••••
Regards,
Ron