exel conditional formula,calculate a bilateral tolerance(.2/-.2)?
 

,I need to set-up a conditional formula in excel , that is able to account
for possible bilateral tolerances, i.e., +0.20/-0.20.
For example: if I want to calculate a Upper Spec. of .20in +/- .005 I would
enter a formula to add upper tolerance to the Target spec. (.005+.20)In this
same way, I substract the enetered MIN. tolerance to the target to obtain my
Lower Spec.
However, What if my Spec. calls for a bilateral tol.: 0.00 in. +0.05/-0,05in.
The above formulation will not work.
Any ideas?
Advise.

Thanks.
Jorge Arvizu.

exel conditional formula,calculate a bilateral tolerance(.2/-.2)?
 

..What if my Spec. calls for a bilateral tol.: 0.00 in. +0.05/-0,05in.

If I'm reading it right, something like this in say, B1:
=IF(AND(A1=LowerLimit,A1<=UpperLimit),"OK","Fail" )

should accomplish the required tolerance check
and return the result as either "OK" or "Fail"

Replace "LowerLimit" and "UpperLimit" in the formula
with the actual numbers, of course

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jorge" wrote:
,I need to set-up a conditional formula in excel , that is able to account
for possible bilateral tolerances, i.e., +0.20/-0.20.
For example: if I want to calculate a Upper Spec. of .20in +/- .005 I would
enter a formula to add upper tolerance to the Target spec. (.005+.20)In this
same way, I substract the enetered MIN. tolerance to the target to obtain my
Lower Spec.
However, What if my Spec. calls for a bilateral tol.: 0.00 in. +0.05/-0,05in.
The above formulation will not work.
Any ideas?
Advise.

Thanks.
Jorge Arvizu.