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.
Answers
-
Are your invoices in separate rows or separate columns? Do you have some kind of unique identifier that will allow us to determine which invoice(s) the payment(s) are to be applied to?
-
Invoices are included in separate columns, we will never have more than 3 open invoices. No Unique identifier. i just may need to redo the format.
-
I'm having a little trouble visualizing. Are you able to provide a screenshot with some mock data entered to show a few examples of what you have and what you are wanting to automate through formula(s)?
Help Article Resources
Categories
Check out the Formula Handbook template!