Page 165 - Computer - 10(A&B)

Value determined
by Goal Seek

Knowledge Plus
Knowledge Plus
Goal Seek helps in finding out the input for the specific output.
Rapid Fireapid Fire
R
Solver Is it possible to find
Solver is the enhanced version of Goal Seek. The difference is that the Solver deals with interest rate at which a
equations with multiple unknown variables. It is specifically designed to minimize or particular amount can be
maximize the result according to a set of rules that you define. borrowed?
Each of these rules sets up whether an argument in the formula should be greater than, lesser than, or equal to
the value you enter. If you want the argument to remain unchanged, you enter a rule that the cell that contains it
should be equal to its current entry. For arguments that you would like to change, you need to add two rules to
define a range of possible values: the limiting conditions. For example, you can set the constraint that one of the
variables or cells must not be bigger than another variable, or not bigger than a given value. You can also define
the constraint that one or more variables must be integers (values without decimals) or binary values (where
only 0 and 1 are allowed).
Once you have finished setting up the rules, you can adjust the argument and the results by clicking the Solve
button.

Using Solver

Let us understand the working of Solver with the help of a simple example. Suppose, a student wants to achieve
80% in his annual exams. To do so, he makes a target (limiting condition) to achieve higher marks in Computer
as compared to Science.
Step 1: Place the cursor in the formula cell i.e., B8

47