Hi
Thanks for getting back to me.
Shebang - 'The whole lot'
So,
I have data spanning across cells A1 to A20.
I want the data in cell A1 to be divided by 2.
Then I want to divide the data in cell A2 by 2 and add the answer from A1 (A1 divided by 2) to it...
-A1 / 2 - Calculation to appear in Cell B1
-A2/2 + A1 - Calculation to appear in Cell B2
-A3/2 +A2 -Calculation to appear in Cell B3
-A4/2 +A3 -Calculation to appear in Cell B4
-A5/2 +A4 - Calculation to appear in Cell B5
repeat...
-A6/2 -Calculation to appear in Cell B6
-A7/2 + A6 -Calculation to appear in Cell B7
-A8/2 + A7 -Calculation to appear in Cell B8
-A9/2 + A8 -Calculation to appear in Cell B9
-A10/2 + A9 -Calculation to appear in Cell B10
repeat...
I hope that this explains it a little bit better
Jenny
|