Formulas dont uppdate automaticly?

R

//R \(Swe\)

I have a cell M95 wich contains this formula =K95/L95*100
I writes numbers in the cells but on some PC's it dont do
the calculating. WHY?

There is same program, same OS, same PC-modell and so on.

Any tip why it doesn't Work?

//R
 
A

Andy B

Hi

It may be that the cell was formatted as text before the formula was
entered. It could be that Tools / Options / Calculation is set to manual. It
could be that Tools / Options / View / Formulas is selected.
It depends, really, on what is actually shown in the cell (the formula? an
incorrect result?)
 

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