Hello,
I am new on this forum and making a quality check sheet for different parts. The idea is that they measure parts with a 'digital marking gauge'. In the sheet I have a cell with the dimension and a cell the maximal deviation.
In an other cell they need to put in the measured dimension. If it is more or than the deviation it need to give FAIL if it is between the deviation it needs to give APPROVED. I tried several formulas but I don't succeed. I hope you can help me with this matter!
Kind regards,
Kars
<tbody>
</tbody>
I am new on this forum and making a quality check sheet for different parts. The idea is that they measure parts with a 'digital marking gauge'. In the sheet I have a cell with the dimension and a cell the maximal deviation.
In an other cell they need to put in the measured dimension. If it is more or than the deviation it need to give FAIL if it is between the deviation it needs to give APPROVED. I tried several formulas but I don't succeed. I hope you can help me with this matter!
Kind regards,
Kars
Dimension |
<tbody> </tbody> |
<tbody> </tbody> | Approved/Fail | ||
<tbody> </tbody> |
<tbody> </tbody> | ... |
<tbody>
</tbody>