Same formulas, but one returns a #DIV/0! error
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.
|