Formula not working

M

mint

I have a formula something like this =ROUND(I34/$J$29,0)

Copied the formula a column of cells and it turn out well as in
=ROUND(I35/$J$29,0) , =ROUND(I36/$J$29,0) , =ROUND(I37/$J$29,0). But even
though the formula has changed, the end value is still the same at the
original cell

Please Help
 
M

muddan madhu

may be calculation is set to manual.

Go to tools | options | calcualtion tab | tick the automatic option |
ok
 

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

Incorporating INDEX function into Array Formula (CNTRL-SHIFT-ENTER 4
#NAME? error in formula in 03 but runs okay in excel 07 4
Macro Error 3
Why am I getting a #VALUE! Error? 6
Vlookup only the last 6 characters 2
Round Len Function Help 19
#div/0! Error 6
IF - how to avoid cells with no value 6

Top