Can Excel calculate a list for me?

C

Chip

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

trip_to_tokyo

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!
 
T

trip_to_tokyo

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
 
C

Chip

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.
 
D

Dave

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
 
T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top