| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula using up 2 10 cells of $ 2 seperate & = $ amt
Thank you all!:) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| how do I create a formula to seperate name into two cells (last, . | Excel Discussion (Misc queries) | |||
Hybrid Mode
