I am having trouble using the solver tool. I am unable to set the constrain, comparison and target cells and I am not sure which are the changing cells. I believe the changing cells are Q11:Q15, the target cells J11:J15, the comparison cells A21:B26 and the constraint cells A3:G7. Is that right and how do I enter it in the solver?
Solved by D. U. in 19 mins