Athos

A

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

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
 
A

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
 
Top