Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel, how can I print a long list on 1 page in multiple colum. | Excel Discussion (Misc queries) | |||
Mailing list in Excel | Excel Discussion (Misc queries) | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) |