So I tried to use Solver to get some values from a subset of values to match a value. The problem is it only works with exact values, but if I have a number like 131.76 and i want something close to it like 131.99 what do i type in Solver?
So I tried to use Solver to get some values from a subset of values to match a value. The problem is it only works with exact values, but if I have a number like 131.76 and i want something close to it like 131.99 what do i type in Solver?
You add constraints. I would recomend that you use cells as reference i.e. add 131.99 in cell B2 and if your target cell is D5
you specify the constraint D5 <= B2
And if you add 131.3 in B3 you could the set a min and a max value for D5 by adding constraint D5 >= B3
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks