Return a yes no value for dat tolerance

**Hollyoak08** · 03-15-2010, 01:08 PM

I have two sets of data
Above 50 Below 50
50.2 49.99
50.4 49.07
50.02 47
50 49
50.01 49.09
50.2 49.99
50.1 49.99
52.08 49.95
50.01 48.08
52 49.8
50.09 48.08
50.9 49.99
53 49.07
52 49.99
50.04 47.99
50.06 47
50.07 49.99
52 49.93
50.12 49.99
50.13 49.96
51 49.6
50.15 48.99
50.23 49.99

I need to see compare each set of data and see which has a tolerance of + or – 0.1 of 50 and then return a yes or no.

**shg** · 03-15-2010, 01:33 PM

In C1 and copy down, =IF(AND(A1<=50 + 0.1, B1> 50 - 0.1), "yes", "no")

**Hollyoak08** · 03-15-2010, 02:16 PM

Find attatched the spreadsheet i have created and included the tolerance level that i need for the data set,i am unsure how ur formula works,i need to compare each value to see if it has a tolerance of either + or - 0.1

**shg** · 03-15-2010, 02:28 PM

Fill in some results manually to show what you want.

**Hollyoak08** · 03-16-2010, 05:19 AM

The first data set shows parts that were made over 50cm i need the fromula to display a true or false value if the part has a tolerance level of either -0.1 or +0.1,the next data set shows parts above 50cm i need the same formula for that.