show % change with input variable for # of rows ahead

I've attached a worksheet showing two columns of numbers, and in column C, the % difference between the current row, and 3 rows back (earlier in time).

I'd like cell E3 to be an input, in which the # of rows back can be changed.

So for example, if we use "1" as the input for E3, then the first value shown would be in cell C5, and the number would be -.59%

I assume we use the ADDRESS function here? Or Offset?

Thanks

Put this formula in cell C5:

=IF(ROWS($1:1)<$E$3,"",B5/INDEX(B:B,ROWS($1:1)-$E$3+4)-1)

then copy down as required.

Hope this helps.

Pete

Thanks Pete.

You're welcome - thanks for the rep.

Pete