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

Giganews Newsgroups
Subject: exel conditional formula,calculate a bilateral tolerance(.2/-.2)?
Posted by:  Jorge
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
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.

Replies