View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Same formulas, but one returns a #DIV/0! error

What am I missing?

What's in C23?

For instance if you have a space in C23 (and Tools/Options/Compatibility
- Transition formula evaluation checked) you'll get #DIV/0.



In article ,
Judy .(donotspam) wrote:

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.