I
inquirer
I am doing something obviously stupid but can't see what
In a spreadsheet I have data in cols A and B
In cell B1 I have =(a1-0.375)
I have copied this to b2.b14 with the result shown:
1 0.625
2 0.625
3 0.625
4 0.625
5 0.625
6 0.625
7 0.625
8 0.625
9 0.625
10 0.625
11 0.625
12 0.625
13 0.625
14 0.625
If I go to cell b2 and then left click in the formula bar then hit enter, b2
evaluates to 1.625. Same with b3, b4 etc.
What have I done to stop the formula evaluating correctly after I have
copied it?
Thanks Chris
In a spreadsheet I have data in cols A and B
In cell B1 I have =(a1-0.375)
I have copied this to b2.b14 with the result shown:
1 0.625
2 0.625
3 0.625
4 0.625
5 0.625
6 0.625
7 0.625
8 0.625
9 0.625
10 0.625
11 0.625
12 0.625
13 0.625
14 0.625
If I go to cell b2 and then left click in the formula bar then hit enter, b2
evaluates to 1.625. Same with b3, b4 etc.
What have I done to stop the formula evaluating correctly after I have
copied it?
Thanks Chris