Problem with Absolute reference

G

Guest

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.
 
G

Guest

Make sure you have Automatic Calculations turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change change cell reference to Absolute reference 5
copy and paste the cell with formula ="1" 3
autoupdate data? 4
auto fill code 3
Excel Iteration Program 5
Referencing a cell even if its contents are moved moved/replaced 6
Multiple options- answer in single cel 2
How To Have A Cell Be Blank If... 2

Top