I have a range of numbers of which I know what I want the sum to be. Some of the numbers need to be negative in order to reach the sum. I need to be able to solve for the sum by knowing which values need to have their positive/negative values changed without changing the actual number - just the +/-. Is Solver capable of this or do I need something else. Any help would be appreiciated
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Solving for value by changing +/- in range
- Thread starter hm
- Start date
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
Welcome to the board!
Here's a trivial example which might help you get on the right path:
Solver definition:
Target = H2
by changing cells: $B$2:$C$3
Constraint 1: $B$2:$C$3 binary
Constraint 2: $D$2:$D$3<= 1
Options:
Precision 0.000000000001
Tolerance 0%
Convergence 0.000000000001
HTH
Here's a trivial example which might help you get on the right path:
Solver definition:
Target = H2
by changing cells: $B$2:$C$3
Constraint 1: $B$2:$C$3 binary
Constraint 2: $D$2:$D$3<= 1
Options:
Precision 0.000000000001
Tolerance 0%
Convergence 0.000000000001
HTH
Upvote
0
