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?

I copy a formula and the results copy from the original cell
 

If the formula adjusted, but the result did not adjust then:

Tools Options... Calculate automatic
--
Gary''s Student - gsnu200732


"brooklynsd" wrote:

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?