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.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!