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 ??

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 ??

Above should read (tabs did not copy across properly):-

InvoiceAmount (column A)
1
2
3
4
5

InvoiceNumber (Column B) (correspoding to above rows):-

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

CustomerPays

3



"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 ??

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 ??

I don't see how you could do that. For example if a customer has 3 invoices,
one for $10, a second one for $10 and a third for $20. He pays you $20. Is
he paying for invoices one and two or is he paying for invoice three? If he
pays you $30, is he paying for invoices one and three or invoices two and
three or is he paying for invoices one and two and making a partial payment
on invoice 3?

Dave


"Chip" wrote in message
...
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 ??

OK, but I don't think that that makes any difference; do you agree?

"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 ??

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 ??