Solver with 2 decimal places

[lark01]

I need to search for a target, using multiple figures located in different cells.
For instance:

INICIO
Uds. PVP Total
1,00 142.500,20 142.500,20
50,00 84,52 4.226,00
52,00 125,30 6.515,60
153.241,80

I would like to find, using Solver, a solution that changing the number of units (with 2 decimal places) would give me the final solution of: 155.201,55

All cells are rounded to 2 decimal places.

As you can see, there is a solution:

Uds. PVP Total
1,01 142.500,20 143.925,20
52,25 84,52 4.416,17
54,75 125,30 6.860,18
155.201,55

The proposed solution of solver is to put in the third column the value:

$C$11 Uds. 67,64046289 0 0 0 1E+30

This solution is not valid for me as it uses more than 2 decimal places.

In the solver options I have set the precision with the value 0.01 as well as the convergence.

Any ideas, to make it work?

Thanks a lot.

[MrShorty]

Solver is not going to round it's solution for you. Is there some reason you cannot round Solver's solution after Solver finds it? When Solver finds 67,64046289 as the solution, can you round that to 67,64 after Solver has finished?

[lark01]

Solver is not going to round it's solution for you. Is there some reason you cannot round Solver's solution after Solver finds it? When Solver finds 67,64046289 as the solution, can you round that to 67,64 after Solver has finished?

not because you would need the exact final result, including decimals

[MrShorty]

I'm not sure I understand the concern. Could you perhaps explain the problem again? Perhaps a sample file illustrating the problem would help (see yellow banner at top of page for instructions on uploading a sample file)?