SOLVED

consume amount inorder

%3CLINGO-SUB%20id%3D%22lingo-sub-3220200%22%20slang%3D%22en-US%22%3Econsume%20amount%20inorder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220200%22%20slang%3D%22en-US%22%3E%3CP%3EDears%2C%3C%2FP%3E%3CP%3ECould%20you%20please%20assist%20regarding%20the%20below%20sample.%20i%20have%20series%20of%20amounts%20and%20i%20want%20to%20consume%20them%20inorder%20based%20on%20the%20paid%20amount%20with%20formula%20to%20be%20like%20the%20below%20ex)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22761%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2281%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E7%3C%2FTD%3E%3CTD%20width%3D%2267%22%3E8%3C%2FTD%3E%3CTD%20width%3D%2282%22%3E%26nbsp%3Btotal%20Dues%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20136%2C579.84%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2036%2C808.15%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2051%2C255.31%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%2033%2C533.46%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2016%2C004.24%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2038%2C333.13%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2020%2C611.28%3C%2FTD%3E%3CTD%3E%26nbsp%3B%202%2C889.43%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20336%2C014.86%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BPaid%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%20254%2C352.70%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%2081%2C662.16%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETo%20Be%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%203%2C824.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2016%2C004.24%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2038%2C333.13%3C%2FTD%3E%3CTD%3E%26nbsp%3B%2020%2C611.28%3C%2FTD%3E%3CTD%3E%26nbsp%3B%202%2C889.43%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%2081%2C662.16%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3220200%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3220889%22%20slang%3D%22en-US%22%3ERe%3A%20consume%20amount%20inorder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1319562%22%20target%3D%22_blank%22%3E%40hussein_elsayed%3C%2FA%3E%26nbsp%3Btry%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DMAX(0%2CB%242-MAX(0%2C%24J%243-SUM(%24A%242%3AA%242)))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3221096%22%20slang%3D%22en-US%22%3ERe%3A%20consume%20amount%20inorder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3221096%22%20slang%3D%22en-US%22%3EThanks!%20You%E2%80%99re%20awesome.%3C%2FLINGO-BODY%3E
Contributor

Dears,

Could you please assist regarding the below sample. i have series of amounts and i want to consume them inorder based on the paid amount with formula to be like the below ex)

 

12345678 total Dues  
  136,579.84  36,808.15  51,255.31    33,533.46  16,004.24  38,333.13  20,611.28  2,889.43  336,014.86 
        Paid   254,352.70    81,662.16
          
To Be         
                   -                  -                  -        3,824.07  16,004.24  38,333.13  20,611.28  2,889.43    81,662.16 
2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@hussein_elsayed try this:

=MAX(0,B$2-MAX(0,$J$3-SUM($A$2:A$2)))
Thanks! You’re awesome.