Athos

is there a way to write this as a formula?

I want each cell (B1:B10) to refer to a fixed cell(A1) in
the following way:

Cell B1 = $A$1 * n. Where n is a value from 1 to 10
So if I drag this formula,
Cell B1 becomes: $A$1 * 1
B2 will be = $A$1 * 2
etc...

Try something like

=$A$1*ROW()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Athos" wrote in message
...
is there a way to write this as a formula?

I want each cell (B1:B10) to refer to a fixed cell(A1) in
the following way:

Cell B1 = $A$1 * n. Where n is a value from 1 to 10
So if I drag this formula,
Cell B1 becomes: $A$1 * 1
B2 will be = $A$1 * 2
etc...

Thanks Chip,
is there any other way to achieve this?

The problem with Row is I have to hard-code the row number
from which I start. What I mean is that if this formula
is in row 120, The I have to hardcode the formula to say
something like... = row()-119...




-----Original Message-----
Try something like

=$A$1*ROW()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Athos" wrote in
message
...
is there a way to write this as a formula?

I want each cell (B1:B10) to refer to a fixed cell(A1)
in
the following way:

Cell B1 = $A$1 * n. Where n is a value from 1 to 10
So if I drag this formula,
Cell B1 becomes: $A$1 * 1
B2 will be = $A$1 * 2
etc...




.

I can't think of any other way to do it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

wrote in message
...
Thanks Chip,
is there any other way to achieve this?

The problem with Row is I have to hard-code the row number
from which I start. What I mean is that if this formula
is in row 120, The I have to hardcode the formula to say
something like... = row()-119...




-----Original Message-----
Try something like

=$A$1*ROW()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Athos" wrote in
message
...
is there a way to write this as a formula?

I want each cell (B1:B10) to refer to a fixed cell(A1)
in
the following way:

Cell B1 = $A$1 * n. Where n is a value from 1 to 10
So if I drag this formula,
Cell B1 becomes: $A$1 * 1
B2 will be = $A$1 * 2
etc...




.

OK,
Thank you Chip for your time



-----Original Message-----
I can't think of any other way to do it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

wrote in message
...
Thanks Chip,
is there any other way to achieve this?

The problem with Row is I have to hard-code the row
number
from which I start. What I mean is that if this formula
is in row 120, The I have to hardcode the formula to say
something like... = row()-119...




-----Original Message-----
Try something like

=$A$1*ROW()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Athos" wrote in
message
...
is there a way to write this as a formula?

I want each cell (B1:B10) to refer to a fixed cell
(A1)
in
the following way:

Cell B1 = $A$1 * n. Where n is a value from 1 to 10
So if I drag this formula,
Cell B1 becomes: $A$1 * 1
B2 will be = $A$1 * 2
etc...




.



.

If I understand you correctly, here's one way:


=$A$1*ROW($A1)

In article ,
wrote:

Thanks Chip,
is there any other way to achieve this?

The problem with Row is I have to hard-code the row number
from which I start. What I mean is that if this formula
is in row 120, The I have to hardcode the formula to say
something like... = row()-119...




-----Original Message-----
Try something like

=$A$1*ROW()

Hi Anthos.........

Try this...........

Type in your formula without the = sign in B1 and drag it down as far as you
wish...........

Then do a "Find and Replace" for the $A in Column B and replace it with =$A

Vaya con Dios,
Chuck, CABGx3




"Athos" wrote in message
...
is there a way to write this as a formula?

I want each cell (B1:B10) to refer to a fixed cell(A1) in
the following way:

Cell B1 = $A$1 * n. Where n is a value from 1 to 10
So if I drag this formula,
Cell B1 becomes: $A$1 * 1
B2 will be = $A$1 * 2
etc...

Hi!

Put 1 to 10 in a column somewhere (I'll assume X1:X10)

Your first value is then $A$1*X1.
Drag down.

Alf


---
Message posted from http://www.ExcelForum.com/

Clever !

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"JE McGimpsey" wrote in message
...
If I understand you correctly, here's one way:


=$A$1*ROW($A1)

In article ,
wrote:

Thanks Chip,
is there any other way to achieve this?

The problem with Row is I have to hard-code the row number
from which I start. What I mean is that if this formula
is in row 120, The I have to hardcode the formula to say
something like... = row()-119...




-----Original Message-----
Try something like

=$A$1*ROW()

The $ is a bit superfluous

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JE McGimpsey" wrote in message
...
If I understand you correctly, here's one way:


=$A$1*ROW($A1)

In article ,
wrote:

Thanks Chip,
is there any other way to achieve this?

The problem with Row is I have to hard-code the row number
from which I start. What I mean is that if this formula
is in row 120, The I have to hardcode the formula to say
something like... = row()-119...




-----Original Message-----
Try something like

=$A$1*ROW()