the formulas on excel aren't working how do I fix it?

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

Guest

When using three cell fo a formula on excel (e.g. A1=1+B1=1...=C1=2).
Although the formula is there in C1 it is still showing C1=0. Only when I
double click on the the cell C1 will the result be equal to 2. How do I fix
this? Ithink the formulas are blocked. Please advise. Pierre
 
I think the mode of calculation may be set to manual, to set it to automatic,
open excel, tools-->options-->calculation-->automatic.
 
Back
Top