Spreadsheet: 727033d1617673043-formula-to-return-ok-or-ng-dependent-on-other-cell-values-aiag-modified-shortened
Sheet: OUTPUT

Dimension/ Specification |  |  |  |  | Supplier Measurement Results |  |  |  |  |  |  | Beyond
Item | Axis | Nominal | - Tol | + Tol | 1 | 2 | 3 | 4 | 5 | 6 | [NAME] | Spec | Mean Dev | Range | OK | NOT | Method
1.1 | 3D | 20.1 | -3 | 3 | 18.729 | 18.779 | 18.783 |  |  |  |  |  |  |  |  |  | CMM |  | CMM
2 | Val. | 6.81 | -0.15 | 0.15 | 6.838 | 6.837 | 6.843 |  |  |  |  |  |  |  |  |  | CMM |  | MIC
3.1 | N.D. | 0 | -0.5 | 0.5 | 0.314 | 0.306 | 0.311 |  |  |  |  |  |  |  |  |  | CMM |  | PIN
3.11 | N.D. | 0 | -0.5 | 0.5 | -0.06 | -0.046 | -0.051 |  |  |  |  |  |  |  |  |  | CMM
3.11 | X | 3464.891 |  |  | 3464.832 | 3464.846 | 3464.84 |  |  |  |  |  |  |  |  |  | CMM
3.11 | Y | -531.612 |  |  | -531.604 | -531.606 | -531.606 |  |  |  |  |  |  |  |  |  | CMM
3.11 | Z | -1487.806 |  |  | -1487.803 | -1487.805 | -1487.806 |  |  |  |  |  |  |  |  |  | CMM
3.12 | N.D. | 0 | -0.5 | 0.5 | -0.121 | -0.11 | -0.114 |  |  |  |  |  |  |  |  |  | CMM
3.12 | X | 3465.302 |  |  | 3465.182 | 3465.193 | 3465.19 |  |  |  |  |  |  |  |  |  | CMM
3.12 | Y | -529.569 |  |  | -529.553 | -529.55 | -529.548 |  |  |  |  |  |  |  |  |  | CMM
3.12 | Z | -1483.891 |  |  | -1483.887 | -1483.891 | -1483.891 |  |  |  |  |  |  |  |  |  | CMM
3.13 | N.D. | 0 | -0.5 | 0.5 | -0.065 | -0.055 | -0.06 |  |  |  |  |  |  |  |  |  | CMM
3.13 | X | 3465.409 |  |  | 3465.345 | 3465.354 | 3465.349 |  |  |  |  |  |  |  |  |  | CMM
3.13 | Y | -527.508 |  |  | -527.5 | -527.501 | -527.501 |  |  |  |  |  |  |  |  |  | CMM
3.13 | Z | -1487.994 |  |  | -1487.991 | -1487.992 | -1487.991 |  |  |  |  |  |  |  |  |  | CMM
13.1 | N.D. | 0 | -0.75 | 0.75 | -0.043 | -0.103 | -0.037 |  |  |  |  |  |  |  |  |  | CMM
13.1 | X | 3526.602 |  |  | 3526.607 | 3526.612 | 3526.606 |  |  |  |  |  |  |  |  |  | CMM
13.1 | Y | -567.105 |  |  | -567.105 | -567.107 | -567.105 |  |  |  |  |  |  |  |  |  | CMM
13.1 | Z | -1470.644 |  |  | -1470.686 | -1470.746 | -1470.681 |  |  |  |  |  |  |  |  |  | CMM
13.2 | N.D. | 0 | -0.75 | 0.75 | -0.104 | -0.178 | -0.107 |  |  |  |  |  |  |  |  |  | CMM
13.2 | X | 3512.684 |  |  | 3512.695 | 3512.705 | 3512.697 |  |  |  |  |  |  |  |  |  | CMM
13.2 | Y | -570.005 |  |  | -570.005 | -570.007 | -570.005 |  |  |  |  |  |  |  |  |  | CMM
13.2 | Z | -1472.107 |  |  | -1472.21 | -1472.283 | -1472.213 |  |  |  |  |  |  |  |  |  | CMM
13.3 | N.D. | 0 | -0.75 | 0.75 | -0.073 | -0.15 | -0.075 |  |  |  |  |  |  |  |  |  | CMM
13.3 | X | 3495.34 |  |  | 3495.348 | 3495.355 | 3495.347 |  |  |  |  |  |  |  |  |  | CMM
13.3 | Y | -569.801 |  |  | -569.801 | -569.801 | -569.803 |  |  |  |  |  |  |  |  |  | CMM
13.3 | Z | -1473.93 |  |  | -1474.002 | -1474.079 | -1474.004 |  |  |  |  |  |  |  |  |  | CMM
13.4 | N.D. | 0 | -0.75 | 0.75 | 0.007 | -0.068 | 0.002 |  |  |  |  |  |  |  |  |  | CMM
13.4 | X | 3479.522 |  |  | 3479.521 | 3479.529 | 3479.522 |  |  |  |  |  |  |  |  |  | CMM
13.4 | Y | -565.872 |  |  | -565.872 | -565.873 | -565.871 |  |  |  |  |  |  |  |  |  | CMM
13.4 | Z | -1475.593 |  |  | -1475.586 | -1475.661 | -1475.591 |  |  |  |  |  |  |  |  |  | CMM
14.1 | Val. | 2.1 | -0.2 | 0.2 | 2.35 | 2.12 | 2.1 |  |  |  |  |  |  |  |  |  | CAL
14.2 | Val. | 2.1 | -0.2 | 0.2 | 2.08 | 2.1 | 2.09 |  |  |  |  |  |  |  |  |  | CAL