Hi,
I was solving some task and needed to use Solver in MS Excel. When I
finished all tables, all conditions and did some settings to Solver and tried
to solve it. I always got a message that Solver didnt find a solution...
The problem is that Solver even didnt try to find it. How do I know that? I
used "Show Iteration Results" and Changing cells always stayed all 0. After 3
iterations Solver stoped and no result was found.
After hours of experimenting with settings I was able to reduce the problem
just to few tables and here it is:

http://www.stud.fit.vutbr.cz/~xslavi13/snap038.jpg

I have some table (Changing table) where Solver is trying to put some
values. Conditions for this area are = 0 and integer. The goal is to have
solution equal of 10. The function in the target cell is SUM of the Countif
table.
The Countif table counts number of columns of the Changing table 0 (using
COUNTIF function).
If you run Solver on this task, NOTHING happens and Solver immediately tells
no solution was found. Solver even does not try to put some initial values.
You can see this when you use Show Iteration Results in Solver options.

Second table IF
There is just simple IF function. If appropriate cell in the Canging table
is 0 then put 1, otherwise 0. If I use SUM of this table for the target
cell, again Solver even does not try to put some initial values end ends
immediately with no result.

Third table SUM
There is SUM of each row of the Changing table. If I use SUM of this table
for the target cell, Solver finds correct sollution.

Why???
Why it does not work for previous two tables???

I put the .xls I am talking about he
http://www.stud.fit.vutbr.cz/~xslavi13/solver1.xls
Note...it came from czech excel, I am not sure if it is not necessary to
rename the function names to English equivalent...

I will explain another problem with Solver in little more complex example...
I have these tables:
http://www.stud.fit.vutbr.cz/~xslavi13/snap039.jpg
Changing table has to be again integers = 0, SUM table below it is sum of
each column of the changing table and the sum has to be equal of 2000, 3000,
etc. SUM to the right of the changing table is sum of each row and each of
this sum has to be <= 10000. If there is at least 1 item in a row of the
Changing table, there is an addition to final prise indicated to the right.
At last, values of the changing table are multiplicated with corresponding
values of the left table and the result is put to the table without any name.
Solution is SUM of the table without any name + SUM of the table Add to
final prise.
What is the problem?
When I use Solver for this problem with default settings, the result is
total nonsence...
OK, I change the precision to 1E-100 , I get again nonsence result BUT even
with decimal digits. How is it possible that if there is condition in the
Changing table that all values have to be integers, Solver puts there e.g.
1044.891 ???

Ok, I use Central Derivatives option, results are not decimals, but again
the result is NOT minimal.

When I change also Estimates to Quadratic I get correct result...
WHy??? According to help, Estimates relates only to some initial values and
have nothing common with the evaluation of the result...

Second .xls I was now talking about can be found he
http://www.stud.fit.vutbr.cz/~xslavi13/solver2.xls

If anyone knows the answers I would be really grateful