copied formulas on Excel the value doesn't change

G

Guest

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
 
G

Guest

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.

---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup matching two values 4
Help with Formula - Concatenate 4
CountIf Formula 1
Simplify Weighted Average Formula 4
Help with If Sum statement - i think.... 4
Copy formula with skipping rows 0
Problem with the 0 value 2
How to use SUMIF to return sums between two values located in cells 1

Top