Calc Guide

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, click the Solve button to
begin the automatic process of adjusting values and calculating
results. Depending on the complexity of the task, this may take some
time.
Solver example
Let’s say you have $10,000 that you want to invest in two mutual funds
for one year. Fund X is a low risk fund with 8% interest rate and Fund
Y is a higher risk fund with 12% interest rate. How much money should
be invested in each fund to earn a total interest of $1000?
To find the answer using Solver:
1) Enter labels and data:
• Row labels: Fund X, Fund Y, and total, in cells A2 thru A4.
• Column labels: interest earned, amount invested, interest
rate, and time period, in cells B1 thru E1.
• Interest rates: 8 and 12, in cells D2 and D3.
• Time period: 1, in cells E2 and E3.
• Total amount invested: 10000, in cell C4.
2) Enter an arbitrary value (0 or leave blank) in cell C2 as amount
invested in Fund X.
3) Enter formulas:
• In cell C3, enter the formula C4–C2 (total amount – amount
invested in Fund X) as the amount invested in Fund Y.
• In cells B2 and B3, enter the formula for calculating the
interest earned (see Figure 236).
• In cell B4, enter the formula B2+B3 as the total interest
earned.
Figure 236: Example setup for Solver
Chapter 9 Data Analysis 291