Carry over numbers after decimal point.

[adamexcel233]

I'm trying to carry over numbers after the decimal point (column in green) and add them to the row belowAt the moment, the RED items are being calculated in each row, and the total is show in BLUE. The number in BLUE is then divided by 7.5 and show in GREEN.



A. 47.50 47.50 47.00 47.00 189.00 25.20
B. 48.50 47.50 44.50 47.50 188.00 25.07
C. 49.00 57.50 53.00 53.50 213.00 28.40


In the GREEN column I have this formula:

=SUM(BLUECOLUMNNUMBER/7.5)

I need to carry over the number in the previous row to the next column, for example:
GREEN Column in B should be 25.27
GREEN Column in Cshould be 25.67

It's probably simple, but can anyone help?
Thanks

 

[Fluff]

How about

Excel 2013/2016
	E	F
3	189	25.20
4	188	25.27
5	213	28.67
asc

Cell Formulas
Range	Formula
F3	=E3/7.5
F4	=E4/7.5+MOD(F3,1)

 

[nigelandrewfoster]

.

 

[adamexcel233]

Thank you FLUFF, much appreciated.

 

[Fluff]

You're welcome