Athos

[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...

 

[Chip Pearson]

Try something like

=$A$1*ROW()


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

 

[Guest]

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...

 

[Chip Pearson]

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


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

 

[Athos]

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




.

 

[JE McGimpsey]

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


=$A$1*ROW($A1)

 

[CLR]

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

 

[AlfD]

Hi!

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

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

Al

 

[RagDyeR]

Clever !

--

Regards,

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

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


=$A$1*ROW($A1)

 

[Bob Phillips]

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]

Certainly, but only the last one. I left it in to make the use of the
relative row reference more obvious typographically.

 

[Bob Phillips]

That's the one I was talking about. How does that make it more obvious
typographically?

--

HTH

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

 

[JE McGimpsey]

Well, perhaps it's just me, but if the "1" is the only character without
a "$" prefix, it emphasizes that the "1" is relative.

 

[Ragdyer]

Why being to picky - picky?
As I said before, it's elemental simplicity is just damned clever!
That's all that really counts (besides ... of course ... attaining the
desired result).