copied formulas on Excel the value doesn't change

J

Jane

When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
the same as D1? But the cell refects the correct formulas.

A B C D
1 122 455 577
2 528 45 577
3 3214 12 577
4 980 12444 577
5 154 87 577
6 31274 855 577
 
M

Max

When i copied formulas from D1 through D6,
why is it that D2 to D6 value is the same as D1?
Click to expand...

The calc mode may be inadvertently set to Manual. Press F9, does it now
compute properly? To check/change calc mode: Click Tools > Options >
Calculation tab. Options are there. Ensure "Automatic" is checked > OK.
 
Top