Hello! I'm having a bit of difficulty trying to figure out the proper equation or formula needed for the proper result. This is my work sheet:
Excel Help 1.xlsx
The first table are measurements taken of real life product and whether they pas of fail a range of criteria. The second table is a range of data that is used to verify if the measurements are in a acceptable range. So if a measured width is 0.25 or less, then the minimum thickness would be 0.125 or else it would be labeled a "Fail". Another Example is if the measured width is 0.25<Measurement>0.37, then the minimum thickness would be 0.25 or else it would "Fail". Hopefully this makes some sense?
My issue is that I'm not sure what formula or equation would be best to use for the Criteria 2 column.
Bookmarks