New to the forum, sorry for any blunders.
I am trying to find 2 dependent variables by changing 1 independent variables. I have attached a picture of my equation. I have found a very complicated way to solve this using Solver in the data tab, but I am hopeful for a better solution. My goal is to only update the referenced cell P to find referenced cells X and Y. Thank you!
-cfdumon
Not sure I'm understanding, but:
x = 5*p/7
y = 2*p/7
Does that help ??
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Could this be a simpler solver setup?
c_solver.jpg
and you may need to change solver constraint precision value. I used 0.00000001 in order to get 0.2 on the left hand side of the equation.
Alf
Last edited by Alf; 06-24-2019 at 10:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks