Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Using Solver to achieve target

0

Why is this solver not working >

Answer
Discuss

Answers

0
Selected Answer

The problem is with the constraints which can only be imposed on the variable cells you specify. If I understand your intention correctly, you want to change the values of D12:F14 in such a way that G9 becomes 900.

Note that, even if your syntax would have been workable, this wouldn't be possible for two reasons. One, G9 is already 900. Two D15:F15 can't remain 0 if values are entered in D12:F14. I deleted all the constraints you had entered and added D12:F14 = int so as to allow only integers.

However, it seems to me that you intention was reaching much further - further than Solver can go. You may require three Solver actions to achieve what you want.

  1. Change D12:F12 (constraint = int) to make G6 = 250
  2. Change D13:F13 (constraint = int) to make G7 = 350
  3. Change D14:F14 (constraint = int) to make G8 = 300 (no change)

This effect can't be achieved with one Solver action.

Discuss

Discussion

Hi Variatus, Thank you very much, your suggestion worked.
Have a great day
rajKS (rep: 2) Apr 8, '18 at 2:27 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login