software

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?

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.

quot;candahopequot; gt; wrote in message
...
gt;I am trying to calculate a formula (that seems simple) but I can't figure
gt;it
gt; out. I need to enter a column of invoice amounts that out of those amts,I
gt; need a fomula to seperate these cells to equal a requested amount in
gt; another
gt; cell. Can anyone help?
lt;It might just be megt;

Don't worry

--
Kind regards,

Niek Otten

lt;Andygt; wrote in message ...
gt; Hi
gt;
gt; 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?
gt;
gt; Andy.
gt;
gt; quot;candahopequot; gt; wrote in message ...
gt;gt;I am trying to calculate a formula (that seems simple) but I can't figure it
gt;gt; out. I need to enter a column of invoice amounts that out of those amts,I
gt;gt; need a fomula to seperate these cells to equal a requested amount in another
gt;gt; cell. Can anyone help?
gt;
gt;

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

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

example here

tinyurl.com/mz7bq
--

Regards,

Peo Sjoblom

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


Thank you all!