| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
11 $ amounts, 6 of the amounts must equal $3854.12, which 6?
I have 11 deposit items and 6 of them equal $3854.12 but how do I find out
which 6 deposits equal the $3854.12. Thanks for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
11 $ amounts, 6 of the amounts must equal $3854.12, which 6?
set up Solver.
In a range parallel to your deposits (assuming your deposits are in C5:C50 for this example), say D5:D50, leave them temporarily blank. in E5:E50 put =D5*C5 and fill down. Put =SUM(E5:E50) in cell E51. Use solver to make D5:D50 be integer, =0, <=1, and use Set value of E51 to be 3854.12. When Solver finishes, you'll have 1's in D5:D50 which correspond to the deposits totalling your desired amount. Bob Umlas Excel MVP "marianne" wrote in message ... I have 11 deposit items and 6 of them equal $3854.12 but how do I find out which 6 deposits equal the $3854.12. Thanks for your help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
11 $ amounts, 6 of the amounts must equal $3854.12, which 6?
Oh - also; Changing cells are D5:D50
"marianne" wrote in message ... I have 11 deposit items and 6 of them equal $3854.12 but how do I find out which 6 deposits equal the $3854.12. Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| EQUAL SIGN | Excel Discussion (Misc queries) | |||
| How do I determine which numbers in a list equal a given sum? | Excel Discussion (Misc queries) | |||
| Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
