Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to find valuce that equal a sum
To all
I'm using Excel 2003. I have a range of values that I need to find a combined total to a specific sum for. Example: The total amount I have is $400 but I have a range of values in 1 column that could equal $400. I need a formual that would show me which values they could be. Thanks c3msmlr |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to find valuce that equal a sum
that would have to be a VB routine, I would think. How many values do you
have? The number of combinations to check for the sum would be the factorial of it. for example, 20 values = 20! = 2,432,902,008,176,640,000 different combinations to check. Someone please check my math! "c3msmlr" wrote: To all I'm using Excel 2003. I have a range of values that I need to find a combined total to a specific sum for. Example: The total amount I have is $400 but I have a range of values in 1 column that could equal $400. I need a formual that would show me which values they could be. Thanks c3msmlr |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to find valuce that equal a sum
You can use Solver. See:
http://www.tushar-mehta.com/excel/te...olver_Template -- Gary''s Student - gsnu200766 "c3msmlr" wrote: To all I'm using Excel 2003. I have a range of values that I need to find a combined total to a specific sum for. Example: The total amount I have is $400 but I have a range of values in 1 column that could equal $400. I need a formual that would show me which values they could be. Thanks c3msmlr |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to find valuce that equal a sum
Here's a link to a thread that discussed the problem:
http://groups.google.com/group/micro...5d2d987b?hl=en Hope this helps. Pete On Jan 24, 3:10*pm, "c3msmlr" <u40919@uwe wrote: To all I'm using Excel 2003. *I have a range of values that I need to find a combined total to a specific sum for. *Example: *The total amount I have is $400 but I have a range of values in 1 column that could equal $400. *I need a formual that would show me which values they could be. Thanks c3msmlr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find first cell in a row not equal to | Excel Worksheet Functions | |||
Formula to find equal values with blank cells | Excel Discussion (Misc queries) | |||
How to:Find the row of the first cell not equal to several values | Excel Worksheet Functions | |||
The formula to find the smallest number in a row not equal to zero | Excel Worksheet Functions | |||
Find combinations of numbers to equal a value | Excel Worksheet Functions |