Solve function?

[Nick M]

I am curious if there is a function that allows you to take a combination of numbers that have been entered and determine any combination of the entered numbers that would = a total. For example a function that would use these numbers
5, 3, 4, 8, 2 and if the number you wanted to reach was 10, the results would be (5,3,2) and (8,2). I hope this is clear. If anyone is aware of such formula, your guidance would be much appreciated. Thank you very much.

 

[Frank Kabel]

Hi
how many numbers do you want to check for any combination?

--
Regards
Frank Kabel
Frankfurt, Germany

I am curious if there is a function that allows you to take a

combination of numbers that have been entered and determine any
combination of the entered numbers that would = a total. For example a
function that would use these numbers:

5, 3, 4, 8, 2 and if the number you wanted to reach was 10, the

results would be (5,3,2) and (8,2). I hope this is clear. If anyone
is aware of such formula, your guidance would be much appreciated.
Thank you very much.