|Subject:||exel conditional formula,calculate a bilateral tolerance(.2/-.2)?|
|Date:||Wed, 10 May 2006|
,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
However, What if my Spec. calls for a bilateral tol.: 0.00 in. +0.05/-0,05in.
The above formulation will not work.