View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brooklynsd brooklynsd is offline
external usenet poster
 
Posts: 1
Default I copy a formula and the results copy from the original cell

I created a simple formula in a cell (D4+E4) and the result is, for example,
100. When I copy the formula into the line below the formula changes to
(D5+E5), however, the result from the original formula, 100, copies into the
cell instead of the result for the new row, say 74. I tried copy, paste
special, formula, without success. Any help?