Copy formula down - cell references change - result is same foral
ace wrote:
Hello,
I am having this problem:
1. I enter this formula in cell D1: A1 + B1 - C1
2. The result is 10
3. I copy the formula down the column
4. All the results in column D are 10 even though the cell references are
adjusted for the new row
Help!
Thanks!
Check that calculation is set to automatic.
|