View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
mint mint is offline
external usenet poster
 
Posts: 2
Default Formula not working

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