Hello,
So I've been trying to tackle this issue for way too long by now. My last resort is asking here for help:
It's an optimization problem i need to solve with Excel Solver. I'm encountering my problems when i want to use IF statements but they don't work with solver and I don't know in what other way i could do it. I have three types of books: 200 - 4 inch, 100 - 8 inch and 80 - 12 inch, all of the books are 0.5 inch wide. Each shelf costs 2300 and 5 per square inch of book. In theory i could have 1 shelf that is 12 inches high, but it can be done cheaper. I've come across the cheapest solution by just trying all of them which is: 1 - 4 inch shelf for 200 books and 1 - 12 inch shelf for 180 books.
What I'm trying to do is let solver change the books variable and have IF statements that check if there is a value higher than 0 in the books cell it adds 1 to that height shelf. But clearly this doesn't work...
Any help is appreciated!
So I've been trying to tackle this issue for way too long by now. My last resort is asking here for help:
It's an optimization problem i need to solve with Excel Solver. I'm encountering my problems when i want to use IF statements but they don't work with solver and I don't know in what other way i could do it. I have three types of books: 200 - 4 inch, 100 - 8 inch and 80 - 12 inch, all of the books are 0.5 inch wide. Each shelf costs 2300 and 5 per square inch of book. In theory i could have 1 shelf that is 12 inches high, but it can be done cheaper. I've come across the cheapest solution by just trying all of them which is: 1 - 4 inch shelf for 200 books and 1 - 12 inch shelf for 180 books.
What I'm trying to do is let solver change the books variable and have IF statements that check if there is a value higher than 0 in the books cell it adds 1 to that height shelf. But clearly this doesn't work...
Any help is appreciated!
Last edited:
