Solver problem

N

nj125

I have a complex equation that is equal to zero with just one unknown that I
have entered as "x". I need to know how to use solver to solve for the
unknown variable. How do I do this? It seems like it should be simple, but
I'm not sure how to enter the unknown into the equation. I keep getting the
error, "Invalid target cell." Which makes me think that I should enter the
unknown into a different cell, or something else. Please help!!!
 
M

Mangesh

Assume some value for this x, and then enter this cell as 'by changing
cell'. Your equation cell should be the target cell.

- Mangesh
 
M

Mike Middleton

nj125 -
I have a complex equation that is equal to zero with just one unknown that
I have entered as "x". I need to know how to use solver to solve for the
unknown variable. How do I do this? It seems like it should be simple, but
I'm not sure how to enter the unknown into the equation. I keep getting
the error, "Invalid target cell." Which makes me think that I should enter
the unknown into a different cell, or something else. Please help!!! <
Click to expand...

You might be able to use Tools | Goal Seek for your task. See Excel's Help
for info.

(Goal Seek often works fine for a single unknown; Solver is required for
multiple unknowns with constraints.)

- Mike
www.mikemiddleton.com
 
Top