Solver - multiple solutions

[cp]

I am working on a table that has ratings from G5:G55, and percent
payouts based on those raitngs in cells H5:H55. I want to be able to
run something (solver maybe), that will fill in the cells in column H
until cell G58 (which tells me I'm out of money) hits zero. The
solutions in column H should be linear in that they should increas at
the same rate.

To complicate matters, I want to be able to tell the "solver" where to
start and finish (i.e. cell H33 should be 1.0 or higher and cell H55
should be 3.0 or lower) and then have it distribute the the variable in
between.

The numbers in column G start at 0.0 and step up in tenths to 5.0.

cp

 

[Bernie Deitrick]

cp,

Use a single cell - let's say, cell H1 - to set your rate of increase, and
reference it in a formula that either applies it linearly: H5, enter a 1,
then in H6, use a formula like
=H5+$H$1
or geometrically:
=H5*$H$1 or =H5*(1+$H$1)
(the better formula depends on how you want to enter the value in H1).

Copy whatever formula that you choose down to H7:H55, and then have solver
vary H1.....

HTH,
Bernie
MS Excel MVP