Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, how can I print a long list on 1 page in multiple colum. Chuck Excel Discussion (Misc queries) 3 March 23rd 05 06:46 PM
Mailing list in Excel Lori Morris Excel Discussion (Misc queries) 1 March 15th 05 09:30 PM
how can I count distinct names in an excel list? RPC@Frito Excel Discussion (Misc queries) 5 February 3rd 05 09:12 PM
How do I put a list of names and e-mail addresses in excel so tha. trav Excel Discussion (Misc queries) 4 December 2nd 04 02:56 AM
How do I import a Windows Explorer list into Excel? Gord Dibben Excel Discussion (Misc queries) 0 December 1st 04 10:20 PM


All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"