I am currently using the Sovler add-in to try and minimize the cost/unit produced of multiple product lines. My sheet is currently setup with a column that you can toggle a program Online by inputting either "Y" or "N". That column drives a lot of different calculations throughout the workbook. Solver runs correctly if I leave this column out and manually turn programs on or off. However, I would like to get to the point where Solver will change the values in that column from "Y" to "N" or vice versa. Is this possible to do or do the variables have to be numbers?
Thank you!
Bookmarks