# Making multiple comparisions using a +/- variable.

#### bobnat

##### New Member
Hi all,

This is something I've been working on and I'm quite stumped. I'm sure it's a simple solution, but I've been going through my books and can't find the answer, probably because my understanding at this point is still limited.

As you can see, I've posted what I'm working with. I want to be able to do the following.

Take the .618 of Reaction 1 (1.2670) and compare it to the .382 of Reactions 2-5. Then compare R2 618 to R3-5 .382 and R3 to R4&5 and finally R4 to R5. In the comparision I want to set a +/- using a variable from .0001 to .001. Then if there is a match, let's say I'm using an .0008 variable, then R1 .618 will match up with R2 .382. This would then be displayed in a separate cell.

I know it's asking a lot. I've actually gotten quite a bit of it done, but to be honest, it's quite convoluted and I'm sure there has to be a much simpler way of doing this. Any suggestions will be greatly appreciated.

Bob

========> 1.2681 .382
========> 1.2670 .618
Reaction 1m

========> 1.2662 .382
========> 1.2638 .618
Reaction 2M

========> 1.2662 .382
========> 1.2638 .618
Reaction 3T

========> 1.2624 .382
========> 1.2576 .618
Reaction 4m

========> 1.2605 .382
========> 1.2546 .618
Reaction 5*

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

##### MrExcel MVP
it would help if you could download colo's html maker (see the lik below this post) & use it to post up a snapshot of you sheet that inlcudes some representative data & an indication of the results you expect...

#### bobnat

##### New Member
Ok, will do.

Bob

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,816
Messages
5,855,795
Members
431,764
Latest member
scottishbigyin

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back