Calculating Wrong

[rafaelapugliese]

I don´t know what is happening!!!

I inserted the formula =b1-a1 and the result appears, but then when I copy and paste (even paste espacial as formula) the results of b2-a2, b3-a3, b4-a4... appears the same of the firts formula. It just modifies when I press F2 and ENTER.

Example:
....A.........B..............C
1..4.........1 (=B1-A1) -3
2..3.........7 (=B2-A2) -3 then, pressing F2 and ENTER the right result appears
3..1.........5 (=B3-A3) -3 then, pressing F2 and ENTER the right result appears
4..6.........3 (=B4-A4) -3 then, pressing F2 and ENTER the right result appears
5..7.........2 (=B5-A5) -3 then, pressing F2 and ENTER the right result appears

HELP!!!!!!!!!!

 

[Jonmo1]

Set your calculation to AutoMatic
tools - options - calculation

Hope this helps...

 

[Andrew Poulsom]

Does it say Calculate in the Status Bar? If so you need to press F9 to update your formulas or choose Tools|Options|Calculation tab and check Automatic.

 

[rafaelapugliese]

Afffff!!!

Thank you!!!!

It worked!!!