Excel error with solver using constraints?

Question

Error message is as follows " Cell Reference Box is empty or contents are not valid"

I tried it in both excel 2007 and 2003

I am trying to add a constraint that is dependent on the data being changed for example cells a1-a4 are selected as changing cells.

in the solver I want to limit say cells a1 a2 and a4 to be <500 combined.

so i select the cells a1+a2+a4 < 500
and the error message pops up
any help would be appreciated.

Answer 1

i am not really clear with ur Q??? please explain me properly i can explain u fir sure

Answer 2

You need to create another cell, say A5, that has the formula:



=Sum(A1,A2,A4)



Then, your constraint in the Solver would be that A5<500. You can only set constraints on one cell (or contiguous range, such as A1:A4) at a time, though you can have a bunch of separate constraints.



Tim

http://feeds.feedburner.com/ExcelBlog

Answer 3

Could probably do an IF statement. Check the variable prior to being put into the matrix.