combination of numbers that equals "X"

Hello Everyone,

I need some help.

The attached excel calculates combinations which goes to target with entered values sums.. Tolerance in excel works both - and + ways. How can i modify macro to tolerance works only + way.

Thank you in advance.

I think that you need to modify this line.

If Abs(t - y) < TOL Then


Try

If t - y < TOL and t - y >= 0 Then

or

If y - t < TOL and y - t >= 0 Then

One of them should work.

Originally Posted by mehmetcik

I think that you need to modify this line.

If Abs(t - y) < TOL Then


Try

If t - y < TOL and t - y >= 0 Then

or

If y - t < TOL and y - t >= 0 Then

One of them should work.

Thank you so much . I tried but did not work.

Please give a sample of an input and an expected output.

Hi mehmetcik,

I entered some numbers in C column in Input page and excel calculated combinations of these numbers sums equals to target, target - tolerance and target + tolerance.
But i want only calculate only combinations of these numbers sums equals to target and target + tolerance . Not target - tolerance
Also I attached excel file and 2 images to explain my target.

Thank you again.

Cut the tolerance in half, then change the target to target + tolerance.

I haven't looked at the workbook.

Let's say the target is $100 and the tolerance is $10 -- that finds totals between $90 and $110, which you don't want.

So change the tolerance to $5 and the target to $105; that finds totals between ____? and ____?