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

may be calculation is set to manual.

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

On Nov 20, 12:59*pm, mint wrote:
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

Have you got the calculation mode set to manual (ToolsOptionsCalculation)?

--
__________________________________
HTH

Bob

"mint" wrote in message
...
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

Thanks, it works great now!

"muddan madhu" wrote:

may be calculation is set to manual.

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

On Nov 20, 12:59 pm, mint wrote:
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