Solver help
 

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

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