ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Solver - Any Tips Please (https://www.excelbanter.com/excel-discussion-misc-queries/63334-solver-any-tips-please.html)

BONJOVI2005

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

cisco7970

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


BONJOVI2005

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


All times are GMT +1. The time now is 05:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com