On Mon, 25 Apr 2005 09:23:06 -0700, "Homeboy"
wrote:
In your original solution you said to put the formula in C1 (which I did),
but 2 lines later in the solver instructions you said to use D1. I did that
and got an error message from solver. I tried a few things and putting C1
rather than D1 worked. I assumed that D1 was a clerical error and the only
reason I mentioned it was in case others were reading this and needed a
similar solution. I actually hesitated to point it out because you have been
so kind in helping me with this that I didn't want to seem ungrateful.
Ah. Now I understand. It's just a matter of having the formula in the same
cell as is specified in the Target section of Solver. And yes, one of those
location entries was a typo.
--ron
|