How to calculate cell values in excel based on the criteria

[Adit]

I am trying to build the logic in Excel where the value gets updated based on the Load criteria. I have attached an example where the row should update once the total of the cells in row 2 is in multiples of the load value. The logic should then take the difference i.e Total - Load and then recalculate for other cells

Any help will be really appreciated. Been trying to build this however not getting my head around it. Please see below example

 

[Adit]

Also have tried below but doesn't give me desired output

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?

23 07 08.xlsm
	B	C	D	E	F	G	H	I	J	K
2	15000	15000	30000	10000	30000	10000	10000	20000	20000	10000
3		15000	30000	0	30000	15000	15000	15000	15000	15000
Load

Cell Formulas
Range	Formula
C3:K3	C3	=INT((SUM($C2:C2)-SUM($B3:B3))/$B2)*$B2

 

[Adit]

Welcome to the MrExcel board!

Is this what you mean?

23 07 08.xlsm
	B	C	D	E	F	G	H	I	J	K
2	15000	15000	30000	10000	30000	10000	10000	20000	20000	10000
3		15000	30000	0	30000	15000	15000	15000	15000	15000
Load

Cell Formulas
Range	Formula
C3:K3	C3	=INT((SUM($C2:C2)-SUM($B3:B3))/$B2)*$B2

Many thanks for the response.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.