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

P

Pierre

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
 
A

aka excel

I think the mode of calculation may be set to manual, to set it to automatic,
open excel, tools-->options-->calculation-->automatic.
 

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

Top