cell formulas

[Fan924]

I would like to use cell A1 as a constant for use on formulas. When I
copy and paste the formula down column C, it no longer points to A1.
Any way to assign A1 a variable name for use in formulas?

 

[OssieMac]

Two ways you can do this.

1. Make it absolute in the formula like the following $A$1. Example =$A$1

2. Name the cell.
In xl2007 Select the cell and then the Formulas ribbon and then Define Name
(In the middle of the Formulas ribbon)

Pre xl2007 Select the cell then menu item Insert -> Name -> Define.

Use your chosen name for the cell like MyConstant. (Avoid reserved words
that are used for formulas etc.)

Use the name in formulas like =MyConstant in lieu of =A1

 

[OssieMac]

A little extra information on absolute addressing. You can place the $ sign
just in front of the column like this $A1 and then you can copy the formula
right across to any column and it will always address column A. However, when
you copy the formula down in the other columns, while it always addresses
column A you will find that the row number changes.

The above is handy to know if you have a value that is always in column A
for the formulas across the worksheet but it is a different value for each
row.

The same with the row numbers. You can use A$1 and copy a formula down and
it will always address row 1. If you copy the formula across then the column
id changes but it will still always address row 1.

Hope this little bit of info helps.

 

[Fan924]

Nice! And so simple.Thanks.