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

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?

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

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.

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

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

<It might just be me

Don't worry

--
Kind regards,

Niek Otten

<Andy wrote in message ...
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.

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

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

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.

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

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?

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

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



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

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

Thank you all!:)