Calculate a Tolerance

[diablo]

Hello all,

I would like to calculate values two cells against dimensional tolerance.
Example, Cell B2 has a base line value of 2.000. Cell C2 has the actual
dimension, lets say it's 2.004. In cell D2 I'd like to display "PASS" or
"FAIL" if the value in cell C2 is greater than or less than cell B2 +/-
0.010.


So if cell C2 is 1.899 it's fail. if it's 2.011 it's fail. If it's between
those two values it pass.


How do I calculate that?

Thanks
Brian

 

[diablo]

Hello all,

I would like to calculate values two cells against dimensional tolerance.
Example, Cell B2 has a base line value of 2.000. Cell C2 has the actual
dimension, lets say it's 2.004. In cell D2 I'd like to display "PASS" or
"FAIL" if the value in cell C2 is greater than or less than cell B2 +/-
0.010.


So if cell C2 is 1.899 it's fail. if it's 2.011 it's fail. If it's between
those two values it pass.


How do I calculate that?

Thanks
Brian

I figured it out, here's what I used.

=IF(C2<B2-0.01,"Fail",IF(C2>B2+0.01,"Fail","Pass"))

It works anyway.

Brian

 

[vandenberg p]

Hello:

Here is one that does not use a nested if.

=IF(ABS(B2-C2)<0.01,"Pass","Fail")

Pieter Vandenberg


: :> Hello all,
:>
:> I would like to calculate values two cells against dimensional tolerance.
:> Example, Cell B2 has a base line value of 2.000. Cell C2 has the actual
:> dimension, lets say it's 2.004. In cell D2 I'd like to display "PASS" or
:> "FAIL" if the value in cell C2 is greater than or less than cell B2 +/-
:> 0.010.
:>
:>
:> So if cell C2 is 1.899 it's fail. if it's 2.011 it's fail. If it's between
:> those two values it pass.
:>
:>
:> How do I calculate that?
:>
:> Thanks
:> Brian
:>
:>
:>
:>

: I figured it out, here's what I used.

: =IF(C2<B2-0.01,"Fail",IF(C2>B2+0.01,"Fail","Pass"))

: It works anyway.

: Brian

 

[diablo]

Thanks, I'll look up the ABS function and read about it.

Brian

 

[Stan Brown]

Hello all,

I would like to calculate values two cells against dimensional tolerance.
Example, Cell B2 has a base line value of 2.000. Cell C2 has the actual
dimension, lets say it's 2.004. In cell D2 I'd like to display "PASS" or
"FAIL" if the value in cell C2 is greater than or less than cell B2 +/-
0.010.

So if cell C2 is 1.899 it's fail. if it's 2.011 it's fail. If it's between
those two values it pass.

Do you really mean that example? It's usual to have tolerances be
relative to the size of the original measurement, not some fixed
number.

If the baseline is 2.000, and your tolerance is 0.010, that's half a
percent. But if the baseline is 0.400, would your tolerance still be
0.010 (2.5%) or would it be 0.002 (half a percent)?

=if(abs(B2-C2)>0.01,"FAIL","PASS")
is what I think you're asking for

=if(abs(B2-C2)>0.005*abs(B2),"FAIL","PASS")
is what I think you should be using.