+ Reply to Thread
Results 1 to 3 of 3

tolerance calculation..

  1. #1
    Registered User
    Join Date
    01-26-2012
    Location
    qatar
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question tolerance calculation..

    hi my dear Friends..
    i want to prepare tolerance calculator in excel sheet,
    i have complete chart for hole and shaft tolerances..
    i need to add or subtract these upper and lower limit in nominal value ..
    so i need to compare that nominal value from whole chart and get both values
    for example:
    Grade NOMINAL HOLE SIZES (mm)
    over 3 6 10 18 30 40 50 65 80 100 120 140 160 180 200 225 250 280 315 355
    inc. 6 10 18 30 40 50 65 80 100 120 140 160 180 200 225 250 280 315 355 400
    H8 18 22 27 33 39 46 54 63 72 81 89
    0 0 0 0 0 0 0 0 0 0 0
    this is the part of that chart what i have..

    i want if i put nominal value 8.365 then according to this chart i get two values
    1) 8.365+0.022=8.387 and 8.365+0=8.365
    actually raw start with H8 , all values are in microns this is why i wrote 0.022 instead of 22.


    please help me..its urgent..


    thank you very much in advance

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: tolerance calculation..

    If it's urgent, you might take a few minutes to read the forum rules about how to get your questions answered quickly.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: tolerance calculation..

    If you post a workbook with sample data and the results you expect it will be much easier to help you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA tolerance loops
    By Stevo56 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2014, 09:16 AM
  2. Return a yes no value for dat tolerance
    By Hollyoak08 in forum Excel General
    Replies: 4
    Last Post: 03-16-2010, 05:19 AM
  3. Vlookup with tolerance
    By Palabalo in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-07-2009, 06:07 PM
  4. how to put a tolerance
    By bolton78 in forum Excel General
    Replies: 1
    Last Post: 02-03-2008, 07:06 AM
  5. Tolerance
    By Odysseus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-27-2007, 12:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1