ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Which Function do I use (https://www.excelbanter.com/excel-discussion-misc-queries/55881-function-do-i-use.html)

Tyler T from TN

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!!


All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com