Solver is
the option that you need. To install solver add in do the following.
the option that you need. To install solver add in do the following.
Go to Excel options → Add ins → Manage add ins → go → select solver add in and press
ok to install it.
ok to install it.
If you have
installed solver, Go to data → in analysis ribbon solver to open the solver
function box.
installed solver, Go to data → in analysis ribbon solver to open the solver
function box.
Ste target
cell is the cell where you want the desired result.
cell is the cell where you want the desired result.
By changing
cell will be the cell that you want to change to get the desired results.
cell will be the cell that you want to change to get the desired results.
Constraints
are the conditions that you want to be followed.
are the conditions that you want to be followed.
Provide the
respective cell addresses and press solve to solve the problem. It will show
all the options to get the desired result.
respective cell addresses and press solve to solve the problem. It will show
all the options to get the desired result.
Enjoy
solving.
solving.
Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.
Leave a Reply