There are several problems that I see:
- Formulas start with an equals sign. Your formula doesn't have one,
so you're just plugging a text string into the cell and it will
presumably display
exactly that string.
- The "i" in your string is simply that - "i". You want to put 4, 5, 6, 7
in instead.
You will need to break the string and concatenate the value of i or -i
into it. I.e.
"=R[" & -i & "]C[4]" or "=R[-" & i & "]C[4]"
- Your example doesn't match your explanation. C[4] off B9 is
column E, not column A. You could use C[-1] to grab the column to the
left of your formula cell, or simply C1 to grab column 1. Similarly,
your
-i based on B9 will give you rows 5, 4, 3 and 2 respectively for i = 4
to 7.
- And last ... even if all this was correct, you would plug four formulas
into
the same cell in very quick succession. So ... it will show all four
items,
but far too quickly for you to see the first three.