Dear Colleague ,
I am interested in writing a simple program to solve following goal seeking function.
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,2728,29,30. = SUM= 465
I want to get new SUM = 400 by modifying given set of numbers. I want to know all possible combinations that I can get sum 400. Are there any tools available for finding such generalize solution ?
1) You can replace any cell (element) by zero(0)
2) You can not change the value of cell other than 0
3) You cannot move the position of value.
Bharat