what is the difference in setting up a formula - using one pr the other

when you copy $B$15 to other cells, it will always be B15, when you copy
$B15, the 15 with change relative to the cells you copy it to.

"mw99" wrote:

what is the difference in setting up a formula - using one pr the other

See "The difference between relative and absolute addresses" in XL Help.



In article ,
mw99 wrote:

what is the difference in setting up a formula - using one pr the other

I posted a response to your previous post. Was it not clear?

Perhaps looking up "absolute and relative references" in the Excel Help will
offer a better description.

HTH,
Elkar


"mw99" wrote:

what is the difference in setting up a formula - using one pr the other

It's Absolute or Relative referencing. It sounds complicated but its not.
Using the dollar signs keeps the reference to the cell constant when you
drag a formula down or across, not using the dollar signs doesn't. You can
Absolute the column, the row, both or none depending on what you want to do.
=$A$1 will stay as =A1 if you drag the formula down or across in another
column.
Without the dollar signs dragging down =A1 will change to =B1, =C1 etc,
dragging across will change to =B1, =C1 etc.
This is an essential part of any spreadsheet, without it one would be typing
forever when dragging formulas.
Check out 'Absolute Reference' in Help, It's all there,
Regards,
Alan.
Regards,
Alan.
"mw99" wrote in message
...
what is the difference in setting up a formula - using one pr the other

Without the dollar signs dragging down =A1 will change to =B1, =C1 etc,
dragging across will change to =B1, =C1 etc.

Thats =A1, A2, A3 etc, my mistake,
Alan.
"mw99" wrote in message
...
what is the difference in setting up a formula - using one pr the other