# Solver constraint

#### tiredofit

##### Well-known Member
I understand Excel's Solver has a constraints limit of 100.

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

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### i_nth

##### New Member
Yes, A1:A3=B1:B3 represents 3 constraints.
If you need more constraints, then look at the alternative free add-in OpenSolver OpenSolver for Excel

#### tiredofit

##### Well-known Member
Yes, A1:A3=B1:B3 represents 3 constraints.
If you need more constraints, then look at the alternative free add-in OpenSolver OpenSolver for Excel
Thanks

I have installed open solver but it seems the free version only solves linear problems.

Am I mistaken?

#### i_nth

##### New Member
You can try the Advanced version of OpenSolver, which includes a couple of non-linear solvers.
Likely a better solution would be to make your model linear (if possible). If you post your model, then we can have a look.

#### tiredofit

##### Well-known Member
You can try the Advanced version of OpenSolver, which includes a couple of non-linear solvers.
Likely a better solution would be to make your model linear (if possible). If you post your model, then we can have a look.
Afraid it contains sensitive info, so can't disclose openly.

Replies
1
Views
106
Replies
1
Views
151
Replies
1
Views
205
Replies
2
Views
117
Replies
0
Views
150

1,148,282
Messages
5,745,836
Members
423,981
Latest member
ph1l

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back