Column's A & B contain raw data.
Column C and D perform simple math calculations on column A & B.
i.e: =ABS($A$7-$B7)
Column E takes the output of C & D, does more math.
i.e: =SQRT((C7*C7)+(D7*D7))
The problem is when I cut and copy, or move the raw data in col's A & B. This creates #REF! errors in Col C,D & E.
In columns C,D and E I have used either relative cell references or absolute cell references to try to fix this problem.
I want to be able to move the data in col's A&B without causing #REF! problems. I want the calculating cells (col's C,D & E) to always reference THE SAME CELL, irregardless of where the data is move around.
I know I am making a silly mistake here, as Absolute cell references like $A$1 should be just that.
I haven't used Excell 2002 or any spreadsheet proggie in many years. What am I doing wrong?
Bookmarks