Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 6
Default Solver - Any Tips Please

I am using solver for an assignment. I have all the constraints in the table and have entered in. When I go to solve the equation, it runs it and the cells come up 0. This is incorrect as I am doing a distribution plan where you have to transport cases and minimize the costs.
Does anyone know what the problem could be. If anyone is willing then you could me your e-mail and have a look at it directly and have a look at it.

Cheers

Martin
  #2   Report Post  
Posted to microsoft.public.excel.misc
cisco7970
 
Posts: n/a
Default Solver - Any Tips Please

this is kinda late; but, any blank cell,space, null, will make the
calculation 0.
cisco7970

"BONJOVI2005" wrote:


I am using solver for an assignment. I have all the constraints in the
table and have entered in. When I go to solve the equation, it runs it
and the cells come up 0. This is incorrect as I am doing a distribution
plan where you have to transport cases and minimize the costs.
Does anyone know what the problem could be. If anyone is willing then
you could me your e-mail and have a look at it directly and have a look
at it.

Cheers

Martin


--
BONJOVI2005

  #3   Report Post  
Junior Member
 
Posts: 6
Default

When you say spaces or blank cells does this mean in the changing cells as there is non. I have the sum product forumula and as far as I k ow its right but nothing is happening.

Martin
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
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Excel Solver Issue nakedbamboo Excel Discussion (Misc queries) 5 November 14th 05 01:26 AM
Trouble with Solver Wanderingspirit99 Excel Discussion (Misc queries) 0 September 12th 05 03:50 PM
Using Solver with VBA EggShell Excel Discussion (Misc queries) 2 August 22nd 05 07:06 AM
Using solver with function with multiple outputs [email protected] Excel Worksheet Functions 5 July 29th 05 01:58 PM


All times are GMT +1. The time now is 10:14 AM.

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

About Us

"It's about Microsoft Excel"