Determine values of parameters that will give a desired result (Solver?)"

I have an excel file that is essentially a pricing tool. It takes into account multiple variables and uses multiple formulas to determine a price. There are a number of cells with drop down menus to select an option that will produce a value to the right of the drop down menu. For example, there is a drop down menu in cell B27, and it has 3 options to choose from. Each option produces a different value to the cell on the right. Depending on what option you choose, it will put a value in cell C27. There are drop down menus in cells B18, B19, B21, B23, B25, B27, B28, B29, B30, B31, and B32. After you've select an option for all of the different drop down menu cells, it uses this formula: =MIN(MAX(PRODUCT($C$17:$C$33)*'Plan Design _ Options'!B7,1-M20),1+M20) In case you were wondering, the value in B7 on 'Plan Design_Options' is 1.18. The value in cell M20 is .4

The value of =MIN(MAX(PRODUCT($C$17:$C$33)*'Plan Design _ Options'!B7,1-M20),1+M20) is multiplied by 53.07 and than divided by 45%. The value after all of that is than divided by 12 and than divided again by 63%. This gives me my price.

What I am looking to do, is find a way that I can get to a certain price by using any combination of the options in the drop down menus. Is there any automated way of doing this other than randomly picking different options from the drop down menus and hoping I arrive at the price I want? I have looked into using Solver or Scenario Manager but I am not very familiar with either of these two and I struggled to get anything to work. If you have any ideas to help me I would greatly appreciate all your efforts to help me solve this problem. Thank you for reading through this and if you have any questions please feel free to ask.

Moderator's Note: Moved from VBA forum --6SJ

Welcome to the Forum!

I'm sorry to have to give you a warning on your very first post but please take the time to review our rules. There aren't many, and they are all important.

I am going to suggest you change your thread title to "Determine values of parameters that will give a desired result (Solver?)"

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)