+ Reply to Thread
Results 1 to 3 of 3

Solver doesn`t change the values

  1. #1
    Registered User
    Join Date
    11-16-2021
    Location
    London
    MS-Off Ver
    office 365
    Posts
    2

    Solver doesn`t change the values

    Hello!!
    I'm an amateur in excel and here on the forum, so I apologize if I do something wrong.
    I want to use solver, with cell E13 (which contains the formula), and with variable cells E15 and E16. But when I use solver, the cells still have the same value. I don't understand what could be wrong.
    Attached Files Attached Files
    Last edited by Primo45; 11-16-2021 at 11:35 AM.

  2. #2
    Valued Forum Contributor Hydraulics's Avatar
    Join Date
    07-15-2018
    Location
    Udine - Italy
    MS-Off Ver
    Office 365
    Posts
    372

    Re: Solver doesn`t change the values

    The formula in cell E13 does not depend on E15 and E16. If you want Solver to optimize those values, you have better link them to your objective function.
    Chemistry isn't my field, so I can't suggest how you should change your model.

    HTH,

    Francesco
    Aim high or don't even try.
    ---------------------------------
    If your question has been answered, don't forget to mark the thread as SOLVED.
    If you find an answer helpful, click on the star icon at the bottom of the post.

  3. #3
    Registered User
    Join Date
    11-16-2021
    Location
    London
    MS-Off Ver
    office 365
    Posts
    2

    Re: Solver doesn`t change the values

    Problem solved! That was the problem. Thank you very much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 12-31-2016, 12:29 PM
  2. Excel 2007 : Solver does not change values
    By RGrahamB in forum Excel General
    Replies: 3
    Last Post: 11-30-2010, 10:24 PM
  3. WHEN EDITING VALUES IN A FORMULA, IT DOESN'T CHANGE TOTALS
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  4. WHEN EDITING VALUES IN A FORMULA, IT DOESN'T CHANGE TOTALS
    By ARIEL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] WHEN EDITING VALUES IN A FORMULA, IT DOESN'T CHANGE TOTALS
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. WHEN EDITING VALUES IN A FORMULA, IT DOESN'T CHANGE TOTALS
    By ARIEL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. WHEN EDITING VALUES IN A FORMULA, IT DOESN'T CHANGE TOTALS
    By ARIEL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1