Burnout Formula - FIFO(First in first out)

[Pinang]

Hi,

I require a formula/VBA code to burnout amount in FIFO basis. attached example file for reference.

Formula should burnout first month value then balance amount from second month. I need a formula in Range(J3:L8).

Thanks in advance.

 

[GraH - Guido]

You can try
[J3]=IF(I3="",MIN($H3,C3),MIN(C3,MAX(0,$H3-SUM($I3:I3))))

 

[Pinang]

Thanks a lot! its' working perfectly