Need a formula too Subtract a value from a previous cell and divide by 6

[wmlim]

Hi There,

I'll try make this as clear as I can and I would appreciate as much help as I can get here.

I need a formula that will

1. First take the value from A1 / 6 and place it into A2
2. Then take the values in (A1 - A2) /6 and place it into A3
3. Then take values in (A1 - A2 - A3) /6 and place it into A4
4. The Process repeats itself, taking the values of the previous cells subtracting and then dividing the subtracted by 6

Here are some values that I hope would make this clearer.

A1 = 10
A2 = A1 / 6 = 1.666667
A3 = (A1 - A2) / 6 = 1.388889
A4 = (A1 - A2 - A3) / 6 = 1.157407

I hope this is clearer..

 

[AlphaFrog]

Excel Workbook
	A
1	10
2	1.666667
3	1.388889
4	1.157407
5	0.964506
Sheet2

Cell Formulas
Range	Formula
A2	=A1/6
A3	=($A$1-SUM($A$2:A2))/6
A4	=($A$1-SUM($A$2:A3))/6
A5	=($A$1-SUM($A$2:A4))/6

 

[wmlim]

Thanks! This is very helpful. Much appreciated.