Change row input!

[stewart08]

Hi exceler's
Got a problem being trying to solve for the last few hours, which may or not use the OFFSET function:

The function has a input value to return a answer from a row of digits.
Simply the 'row input value' locates ref row (if 1, its 1 row up...) and then adds the right cell vaule.

rows = 1 input means use 1: row up, 2: use 2 rows up etc...

values anwers row
A1: B1: C1: D1:
8 0 Row 2
1 0
2 6
3 2
1 1
6 3
6 5
7 1
8 2
3 4

work sheet file

[ChemistB]

In B1 copied down

=IF(ROW()-1<row,0,A1+INDEX($A$1:$A$10,ROW()-row))

Does that work for you?

[stewart08]

thats working very well thanks ChemistB
I have another more complex problem I'm trying to solve may be you could help me out, should I open a new trend and send you the link...

[ChemistB]

Yes, open a new thread. Glad I could help.

[stewart08]

ok I posted it, hope you could help, its under the excel forex thread.

[royUK]

Attach workbooks to the Forum post not in links to xysoft!!!!

[stewart08]

ChemistB,
One last question; how could I reserve the process i.e. instead of refer to up rows I now need to ref to down rows, what do I change in the formula to do this thanks...

=IF(ROW()-1<row,0,A1+INDEX($A$1:$A$10,ROW()-row))

[ChemistB]

Try

=IF(ROW()-1<row,0,A1+INDEX($A$1:$A$10,ROW()+row))
Does that work?