tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
I understand Excel's Solver has a constraints limit of 100.
Here are 3 constraints:
Is the following also considered to be 3 constraints or just 1?
The problem I am trying to solve exceeds the limit of 100 constraints and I am trying to "squash it down" by combining them.
Thanks
Here are 3 constraints:
Code:
A1=B1
A2=B2
A3=B3
Is the following also considered to be 3 constraints or just 1?
Code:
A:1:A3=B1:B3
The problem I am trying to solve exceeds the limit of 100 constraints and I am trying to "squash it down" by combining them.
Thanks