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

Challenging Solver Equation

0

I have a very confusing issue. I would like to create a solver program that will automaticall configure the percents of "Lot 1 and Lot 2" which is depicted in yellow to get the cell in gray to be .15 exactly. The numbers to the left and right are the independent variables. The handwritten equation would be (.17*.33)+(.14*.67)=15 but I want excel to do the math automatically for me and be exact.

The example is an attached file which will help with some descriptions I have put in the question.

Answer
Discuss

Answers

0

in your example use this

=(A3*B3)+(D3*C3)

Discuss


Answer the Question

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