View Single Post
 
Old 06-14-2013, 12:29 AM
Jenny345 Jenny345 is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Jun 2013
Posts: 2
Jenny345 is on a distinguished road
Default

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
Reply With Quote