how do you insert a formula into a cell reference (ie A(1+n)

[chukwa]

how do you insert a formual into a cell reference

i want to create a formula where by the formula is A(1+n)

where n is a variable i can change......

not quite sure how to do it

if somebody could help!!!

 

[XLGibbs]

In VBA or Formula?

and how is the variable going to change....via a cell reference on the sheet, or in code somehow?

 

[chukwa]

all done in excel........

variable is going to be adjusted using another cell reference

example i want the formula to read

A(1+N)

N= number (which can be adjusted)

so if i adjust n = 7

then the cell reference would be A8 = A(1+7)

not sure how to do this in excel

 

[Norie]

Use INDIRECT.

=INDIRECT("A" & 1+B1)