what does error message "too many adjustable cells" mean in solver
I am new to solver, and am trying to find a solution using a column of
numbers. Basically I want to find the sum of 4311.20 in a list of numbers . My target cell has the formula =sumproduct(actuals,ones) where actuals is the name of the cells to use for the solution, and ones is for the binary number. In solver I am selected the target cell with the formula, value = to 4311.20, by changing cells has the word "ones" for the column with ones in it, and the constraints are ones=binary. I get the error message "Too many adjustable cells". |
what does error message "too many adjustable cells" mean in solver
Solver... I get the error message "Too many
adjustable cells". Hi. The Solver that comes with Excel is limited to 200 Changing Cells. = = = = = HTH Dana DeLouis dee wrote: I am new to solver, and am trying to find a solution using a column of numbers. Basically I want to find the sum of 4311.20 in a list of numbers . My target cell has the formula =sumproduct(actuals,ones) where actuals is the name of the cells to use for the solution, and ones is for the binary number. In solver I am selected the target cell with the formula, value = to 4311.20, by changing cells has the word "ones" for the column with ones in it, and the constraints are ones=binary. I get the error message "Too many adjustable cells". |
All times are GMT +1. The time now is 04:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com