cell references
 

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

cell references
 

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