formula using up 2 10 cells of $ 2 seperate & = $ amt

[Guest]

I am trying to calculate a formula (that seems simple) but I can't figure it
out. I need to enter a column of invoice amounts that out of those amts,I
need a fomula to seperate these cells to equal a requested amount in another
cell. Can anyone help?

 

[Guest]

Hi

It might just be me, but I don't understand what you want. You have a column
of invoice amounts - and what do you want from it?

Andy.

 

[Niek Otten]

<It might just be me>

Don't worry

 

[Guest]

I get an invoice requesting let's say $41000.00 to be pd, I have individual
job invoices of smaller amounts (ex: 1724.69, 470.37, 26005.24, 16163.73)
what I am trying to do is using the smaller invoices get as close as I can to
the requested amout of 41,000. Can this be done and am I a little bit more
clear this time? It's hard to explain w/o the actual paperwork.

 

[Guest]

I get an invoice requesting let's say $41000.00 to be pd, I have individual
job invoices of smaller amounts (ex: 1724.69, 470.37, 26005.24, 16163.73)
what I am trying to do is using the smaller invoices get as close as I can to
the requested amout of 41,000. Can this be done and am I a little bit more
clear this time?

 

[Peo Sjoblom]

If you know that some of the se invoice will make up the total you can use
solver

example here

http://tinyurl.com/mz7bq



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

Thank you all!