View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
skimna7
 
Posts: n/a
Default Equations Result in 0


Hi,

I have had these worksheets with varying equations ranging from all
sorts of complexity, from simple SUM and DATEDIF functions to triple IF
conditions. These worksheets have been working for months flawlessly,
however, recently when I do anything in my excel books, I have run into
quite the situation. Everytime I click on a cell with a formula or
function, and I press enter afterwards, the value returned becomes a
'0' instead of what value it should result in. Or if I decide I want to
change the formula to refer to another cell in part of the formula,
again the resulting value in the cell becomes a '0'. I dont understand
what is going on. Any insight would be extremely helpful.

Thanks!


--
skimna7
------------------------------------------------------------------------
skimna7's Profile: http://www.excelforum.com/member.php...o&userid=32708
View this thread: http://www.excelforum.com/showthread...hreadid=525389