is there a way to create a function that can apply funds across multiple cells if the funds received exceed an amount referenced in another cell?
example: funds received in the amount of $5,000, we have 2 outstanding invoices totaling $11,000.
invoice 1 = $3,000
invoice 2 = $8,000
can a formula "apply" the $5,000 to clear invoice 1 and apply the remainder to invoice 2?
hope this is clear and thank you for your help.