Solver constraints divisible by number

[agelcer]

I'm trying to use Solver to calculate some values, but I need the values that Solver spits out to be divisible by 22.

I've tried entering "MOD(A1,22) = 0" as a constraint, but Solver stops understanding it as linear.

Any ideas how I would achieve this?

 

[BSALV]

declare that variable as an integer ?

 

[agelcer]

declare that variable as an integer ?

Solver only allows variable cells to be integers. Cannot force constraints to be integers.

 

[BSALV]

use 2 variables, the 1st is the double variable and the 2nd the integer.
There is one constraint with the 2nd <= the 1st.
in certain constraints you use the first, in others the second
That's the way.
Can you post or describe your problem ?

 

[agelcer]

Manage to solve the problem in a very easy way.

The model should MAX "Total profit" limiting "Total cost" to "Budget". Column "Decision" has the variable cells that Solver should adjust.

Group A is my previous work, where I was trying to force multiples using constraints.

Group B is the simple solution. I added column "Multiple" and, now, both total columns also multiply the "Multiple".

Thank you BSALV, your suggestion led me to this solution.