So, whatever you put in the if formula will be returned, just change it to

=IF(C23=0,0,G23/C23)


--


Regards,


Peo Sjoblom



"Judy" .(donotspam) wrote in message
...
Thank you so much for the responses. This suggestion worked...sort of.

After using the suggested formula I have a blank cell (no more errors!)
but
the cell formatting is lost. So even though the cell formatting indicates
percentage with one decimal point (the cell should read 0.0%) it is blank
instead.

I'll keep trying....

"Peo Sjoblom" wrote:



Try this

=IF(C23=0,"",G23/C23)

If C23 is empty then it equals zero in this formula





--


Regards,


Peo Sjoblom


"Judy" .(donotspam) wrote in message
...
In one cell I have the formula
=IF(ISBLANK(C16)," ",G16/C16)
which returns a 0 value in a particular cell if the numbers in the
corresponding cells are 0.

The problem is, I have the same formula copied to reflect a different
row's
calculations
=IF(ISBLANK(C23)," ",G23/C23)
but see instead a #DIV/0! instead of a 0.

What am I missing?

Thank you for your time.