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