Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Excel Solver Issue | Excel Discussion (Misc queries) | |||
Trouble with Solver | Excel Discussion (Misc queries) | |||
Using Solver with VBA | Excel Discussion (Misc queries) | |||
Using solver with function with multiple outputs | Excel Worksheet Functions |