- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- exel conditional formula,calculate a bilateral tolerance(.2/-.2)?

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.

- Re: exel conditional formula,calculate a bilateral tolerance(.2/-.2)? posted by MAX on Wed, 10 May 2006