You have three unknowns, x, p, and l, and one equation. That means you
have an infinite possible solutions. To get one possible solution,
assign any value to 2 of the unknowns, say, x, and p, and solve
algebraically for the third. l=(M-(A1/B1)/(x(T/Y)^p))/(1/E+1)
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
In article ,
says...
i was wondering how i set up solver to solve for a certain equation. i
am new to excel and need all the help i can get. thanks. the equation
is:
A1/B1 = x (T/Y)^p (M-l/E-l)
i have A1, B1, T, Y, M and E but want to see what the best values for
the other parameters are.
^ = exponent
can someone please help an old fool?
--
laskuh