cell references

A

amy howell

How do you know when to use a relative, absolute, or mixed reference? Are
there certain instances to use each one?
 
J

Jim Thomlinson

Generally speaking yes...
A simple exercise to show absolute vs releative reference is to create a
Multiplication Table
In cells A2:A10 put the numbers 1 to 9
In cell B1:J1 put the numbers 1 to 9
Now create a multiplication table using only 1 formula and dragging it.
The correct answer is in Cell B2 add the formula
=$A2*B$1
You don't want the A to increment as you drag but the 2 has to increase. The
same is true of the 1 and the B. Try it and see.
 

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

Switch between relative, absolute, and mixed references 3
Absolute and Relative Cell References 1
Range of cells: Convert relative reference into absolute 5
References to external workbooks in excel 2
How do I copy a combobox to many cells with relative reference? 1
Change relative to absolute references in a block of cells 3
Formulas 1
Change a cell reference from relative to absolute 2

Top