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>

 

[Peter_SSs]

Formula in I5 is copied left.

There ARE situation when H3="" & I3=""
Then your formula does not works. I have to manually punch 0s in H3 & I3 to achieve the result.

Can the formula be adjusted to take care of NULLs in B3:I3?

Yes, I5, copied left
=MAX(MIN(N(I3),$J$4-SUM(J3:$J3)),0)

 

[hsandeep]

=MAX(MIN(N(I3),$J$4-SUM(J3:$J3)),0)[/QUOTE]
Thank You

 

[Peter_SSs]

Cheers.

 

[hsandeep]

Yes, I5, copied left
=MAX(MIN(N(I3),$J$4-SUM(J3:$J3)),0)

J4 contains formula & can generate "". In such case B5:I5 generates #VALUE !.

Can it give 0 (Zero) instead?

 

[Peter_SSs]

J4 contains formula & can generate "". In such case B5:I5 generates #VALUE !.

Can it give 0 (Zero) instead?

Sure

=MAX(MIN(N(I3),N($J$4)-SUM(J3:$J3)),0)

 

[hsandeep]

=MAX(MIN(N(I3),N($J$4)-SUM(J3:$J3)),0)

Thats it.IT WORKS CHEERS