Move to next cell when value reached

[Sheene1976]

Hi everyone, first post so apologies if this type of thing has been covered previously.

As per my screenshot, I have a list of the NFL stadiums (2019/2020 season I think) and the distances in miles between each stadium. My columns are as follows:-

A - Start point
B - Target point
C - distances between two points in miles
D - Rolling total of miles between points
F - miles I have to cover before I get to the next stop
H - Stop reached - formula you can see

What I want to do is have something set up where when I get to the next stop, my distances stop counting and move to the next one e.g. going from Seattle to San Francisco, I have 733.2 miles to go before I get to the 49ers stadium so when cell F2 reaches 0, that cell stops counting but F3 still counts down until it reaches 0, etc.

 

[Crystalyzer]

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			Dist	Cumul		Miles to next Stop		Stop Reach				Miles Done
2			835	835		0						1200
3			362	1197		0
4			277	1474		274
5			285	1759		559
6			1065	2824		1624
7			265	3089		1889
8			354	3443		2243
9			628	4071		2871
10			260	4331		3131
11			332	4663		3463
12
13
14
Sheet4

Cell Formulas
Range	Formula
D3:D11	D3	=+D2+C3
F2:F11	F2	=IF($L$2>D2,0,D2-$L$2)

 

[Joe4]

Note that the formula:

=IF($L$2>D2,0,D2-$L$2)

can be simplified a little to this:

=MAX(D2-$L$2,0)

 

[Sheene1976]

Thanks for this, worked a treat