Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Which Function do I use
I want excel to give me each scenerio of adding either some or all of a group
of numbers, whether they were positve or negative, that would yield a particular value. For example, the avaiable group has the numbers 1, 2, 3, 4 and 5 and I want to know what combination of those five numbers when added together, either using all of the numbers or only part of them or even switching some of their signs to negative, would give me the value of 3. So, the answer I want from excel is to say: 1+2=3 or 4-1=3 or 5-2=3 or 2+4-3=3 or 5+4-3-2-1=3, etc. Anybody have any clue how to setup that system? Many thanks to you all in advance...you're all smart in my book. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |