View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ZT
 
Posts: n/a
Default Not obtaining the correct result

I have a very simple formula. I am subtracting two values and the result
should be a large number. The only value returned is zero. I have checked
the cell format, I have traced the cell references and I do not find anything
obvious. If I enter the same formula in a different cell, I get the correct
result?!?!?

The cell is not procted, so does anyone have any idea why zero is appearing?