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

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

Jim Thomlinson


"amy howell" wrote:

So, if I have a formula in column A, that references a certain cell or cell
range, and I want to have that same formula in one or multiple cells, I use
an absolute reference? On the other hand, if the formula does not need to
remain constant, I would use a relative reference? Is my understanding
correct?
--
Amy Howell


"Jim Thomlinson" wrote:

If you do not intend to drag or copy a formula then it makes no difference.
If however you intend to drag or copy you need to think about the reference
style. Absolute references will not change so if your formula always needs to
reference a specific cell, column or row then you need to add absolute
references. If on the other hand the formula depends on the relative position
of another cell then you want relative references.
--
HTH...

Jim Thomlinson


"amy howell" wrote:

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