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?
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?