I reckon that the customer would have to give you the amount(s) and the
invoice number(s) that it (they) went against in order for you to be able to
reconcile what was going on. I can't see them having a problem with that.

"Chip" wrote:

I understand, but the invoices are not whole numbers, so to speak. They are
amounts from .01 to 1999.99 and the check would be for a weird amount,
too. I would doubt if there would ever be two ways to calculate it.

"trip_to_tokyo" wrote:

Chip, this is what you seem to be saying:-

InvoiceAmount InvoiceNumber CustomerPays

1 1,000
2 2,000
3 3,000 3
4 4,000
5 5,000




If customer pays 3 it could go against either Invoice Numbers 1,000 and
2,000 or just 3,000 alone so I think that the answer to your question is no.

If my comments have helped please hit Yes.

Thanks!



"Chip" wrote:

I have a list of invoices with the amount of each. I know how much a
customer paid. He didn't give me the invoices he wanted to pay for. Given
that I have the total, can Excel calculate the correct list of amounts
(invoices) the customer is paying for ??