View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Judy[_2_] Judy[_2_] is offline
external usenet poster
 
Posts: 4
Default Same formulas, but one returns a #DIV/0! error

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.