Is there a way that I can use one cell as a quotient for a formula in a
column without editing the formula each time?

Example:

A12= 1.04

C15 =A15-B1
C16=A16-B1
C17=A17-B1
C18=A18-B1

Auto Fill will start filling B1 thru Bx

Can I give B1 an alias that I can refer to in my formula that Autofill
wont try to correct?

Change the formula in C15 to =A15-$B$1 then copy down.

The $ signs anchor B1

For more on this see help on absolute and relative cell refences.


Gord Dibben MS Excel MVP


On 21 Nov 2006 11:38:56 -0800, "Epoh Rio" <(E-Mail Removed)> wrote:

>Is there a way that I can use one cell as a quotient for a formula in a
>column without editing the formula each time?
>
>Example:
>
>A12= 1.04
>
>C15 =A15-B1
>C16=A16-B1
>C17=A17-B1
>C18=A18-B1
>
>Auto Fill will start filling B1 thru Bx
>
>Can I give B1 an alias that I can refer to in my formula that Autofill
>wont try to correct?

Incomplete answer..........

You could give B1 a name(alias)under Insert>Name>Define.

The your formula would look like =A15-qwerty

qwerty is the name you gave to B1


Gord

On Tue, 21 Nov 2006 11:44:18 -0800, Gord Dibben <gorddibbATshawDOTca> wrote:

>Change the formula in C15 to =A15-$B$1 then copy down.
>
>The $ signs anchor B1
>
>For more on this see help on absolute and relative cell refences.
>
>
>Gord Dibben MS Excel MVP
>
>
>On 21 Nov 2006 11:38:56 -0800, "Epoh Rio" <(E-Mail Removed)> wrote:
>
>>Is there a way that I can use one cell as a quotient for a formula in a
>>column without editing the formula each time?
>>
>>Example:
>>
>>A12= 1.04
>>
>>C15 =A15-B1
>>C16=A16-B1
>>C17=A17-B1
>>C18=A18-B1
>>
>>Auto Fill will start filling B1 thru Bx
>>
>>Can I give B1 an alias that I can refer to in my formula that Autofill
>>wont try to correct?

Thanks Gord!!