 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007Calculate a Tolerance
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 > Hello all, > [quoted text clipped - 11 lines] > 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 Hello: Here is one that does not use a nested if. =IF(ABS(B2-C2)<0.01,"Pass","Fail") Pieter Vandenberg :> Hello all, :> [quoted text clipped - 11 lines] :> 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 Thanks, I'll look up the ABS function and read about it. Brian > Hello: > [quoted text clipped - 30 lines] > > : Brian Sat, 14 Apr 2007 19:02:31 -0400 from diablo <nomail@mail.not>: > Hello all, > [quoted text clipped - 6 lines] > 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.  SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.