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.

Sorry, Excel 2000:-)

WakY pÃ*Å¡e:

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.

Make sure you have Automatic Calculations turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar


"WakY" wrote:

Sorry, Excel 2000:-)

WakY pÃ*Å¡e:

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.

thanx, this is my problem, thanx:-)

Elkar pÃ*Å¡e:

Make sure you have Automatic Calculations turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar


"WakY" wrote:

Sorry, Excel 2000:-)

WakY pÃ*Å¡e:

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.