View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
candahope
 
Posts: n/a
Default 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?