Results 1 to 9 of 9

Compare numbers to a tolerance range

Threaded View

  1. #3
    Registered User
    Join Date
    10-12-2009
    Location
    WI
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Compare numbers to a tolerance range

    I've attached an example. In the top I would like to be able the dimensions I have for the part. There will be at least ten of these tables that I would like to be able to search through using this method, it would be very easy to put them all on one sheet as well. I just need a way for it to find which standard and what Nominal Size that the washer would fall into. I'm not sure if there's a way to display the text of the size and table name at the top or even highlighting the row that it's in would be sufficient.

    Thanks for any help!

    Here's the table incase the attachment doesn't work:

    ID OD Thickness
    Enter Value Enter Value Enter Value


    Commercial Flat Washers - 316 Stainless
    OD ID Thickness
    Size Max Min Max Min Max Min
    1/4 0.63 0.62 0.286 0.276 0.055 0.045
    1/4 0.693 0.683 0.286 0.276 0.055 0.045
    5/16 0.755 0.745 0.348 0.338 0.055 0.045
    3/8 0.88 0.87 0.411 0.401 0.055 0.045
    3/8 1.005 0.995 0.411 0.401 0.055 0.045
    1/2 1.255 1.245 0.567 0.557 0.067 0.057
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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