Fill values top down

[hsandeep]

B2:B9 is +ve Integers
C1 is Value
Output Required in D2:D9 as TO FILL VALUES STARTING D2 & Considering range B2:B9 TOP DOWN
Thanks in advance
Sheet1

	B	C	D
1		2000
2	400		400
3	750		750
4	800		800
5	1000		50
6	50		0
7	95		0
8	80		0
9	8000		0
10

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

 

[Joe4]

Place this formula in cell D2 and copy down to cell D9:

=MAX(MIN(B2,$C$1-SUM(B$1:B1)),0)

 

[hsandeep]

Place this formula in cell D2 and copy down to cell D9:

=MAX(MIN(B2,$C$1-SUM(B$1:B1)),0)

Thanks IT WORKS

 

[hsandeep]

Place this formula in cell D2 and copy down to cell D9:

=MAX(MIN(B2,$C$1-SUM(B$1:B1)),0)

Joe What to do if values are HORIZONTAL (in ROWS) & to be adjusted from RHS to LHS
Sheet1

	B	C	D	E	F	G	H	I	J
3	500	1000	9	8	2	700	200	500
4									1500
5		81	9	8	2	700	200	500

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

 

[Joe4]

I do not understand the new layout your provided. I am not sure what those 9, 8, 2, and 81 number references are.
I am not sure what RHS and LHS stand for either.

Why the drastic change from the original format?

 

[Peter_SSs]

What to do if values are HORIZONTAL (in ROWS) & to be adjusted from RHS to LHS

Like this?
Formula in I5 is copied left.

Excel 2016
	B	C	D	E	F	G	H	I	J
3	500	1000	9	8	2	700	200	500
4									1500
5	0	81	9	8	2	700	200	500
Sheet4

Cell Formulas
Range	Formula
I5	=MAX(MIN(I3,$J$4-SUM(J3:$J3)),0)

 

[Marcelo Branco]

Or

	B​	C​	D​	E​	F​	G​	H​	I​	J​
3​	500​	1000​	9​	8​	2​	700​	200​	500​
4​									1500​
5​	0​	81​	9​	8​	2​	700​	200​	500​

B5 copied across
=MAX(MIN(B3,$J$4-SUM(B3:$I3)+B3),0)

M.

 

[hsandeep]

RHS Right Hand Side
LHS Left Hand Side

I am adjusting J4 in B3:I3
Output in B5:I5

Here
J4 1500
So 1^st I3 adjusted & I5=500
Then Still balance left (1500>500)

So 2^nd H3 adjusted & H5=200

& so on

I hope I am clear.

 

[Joe4]

It looks like you got two responses already on the recent request, so see if either (or both) work for you and post back.

 

[hsandeep]

​

Worksheet Formulas Cell Formula I5 =MAX(MIN(I3,$J$4-SUM(J3:$J3)),0) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

[/QUOTE]

Great to see you Peter. IT WORKS. Thanks & Regards