Hi,
Need your help with excel formula for Distributing stocks to requirements until it becomes zero.
Attached a sample carrying input in sheet1 and expected result (and conditions) in sheet 2.
Anyhelp is grealty appreciated.
Thanks
Babu.S
Hi,
Need your help with excel formula for Distributing stocks to requirements until it becomes zero.
Attached a sample carrying input in sheet1 and expected result (and conditions) in sheet 2.
Anyhelp is grealty appreciated.
Thanks
Babu.S
Thanks
Babu.S
=MAX(0,MIN(C2,C2-(VLOOKUP(B2,E$2:F$6,2)-SUMIF($B$1:B1,B2,$C$1:C1))))
in D2 and copy down
Thanks yudlugar. it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks