Hi All,
I am experimenting with solver and have attached an example of my problem.
A3:A12 contains a list of numbers from 1 to 10. B3:B12 are my cells I wish to change to be either 1 or 0. If a cell in column B equals 1 then it multiplies the corresponding number in column A by 1 and puts the result in column C. Column C is summed up in cell C14.
My solver settings are below:
Target: $C$14=11
By Changing: $B$3:$B$12
Subject to constraints: $B$3:$B$12=Integer
Effectively, I'm giving solver a number, in this case 11, and I'd like it to return the possible combinations of the numbers 1 to 10 that can sum up to = 11 (eg, 5 and 6, 1 and 10, 4 and 7, etc.)
When I run the solver though, it sometimes changes the cells in column B to be a decimal, even though I have used the "Subject to constraints" option to ensure they are only changed to integers.
Is anyone able to tell me what I am doing wrong?
Brad.