Problem with Absolute reference
Hi,
I have problem with absolute reference. For example:
Cell A1 =$B$1*C1 Cell B1= 10 Cell C1 = 100
Cell A2 =$B$1*C2 Cell B1= 10 Cell C2 = 200
Cell A3 =$B$1*C3 Cell B1= 10 Cell C3 = 300
Problem is, that the final value in cells A1, A2 and A3 is SAME !!! ...final
formulas in these cells are right, but final value is same as in cell A1.
|