How to - applying funds

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!