1+1=0??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my old excel files (same Excel version 2003), all the calculations returns
0.
If I try in a new cell this formula: =1+1 it returns 0.
All my formula calculations, SUM's, AVERAGE's had stoped running.

But if I open a new excel file all works fine.

Any help?
Thank you.
 
Have you checked that Tools/ Options/ Calculation is set to automatic, not
manual?
 
It was checked to automatic, moreover I tried to change to manual then to
automatic again. Saved and closed. When I open all formulas started to work.
Has no sense, but it worked.
Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
Formula returns #N/A 1
Countif 7
Creating a Unique List 5
Excel Average dates help 0
If statement with time 15
Optimising calculation time 11

Back
Top