Formula for a Deviation

[Kars1995]

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

Dimension	± <tbody> </tbody>	Measured <tbody> </tbody>	Approved/Fail
15,6 <tbody> </tbody>	0,1 <tbody> </tbody>	...

<tbody>
</tbody>

 

[Tetra201]

Try this:

=IF(ROUND(ABS(C2-A2),6)<=B2,"Approved","Fail")

 

[Kars1995]

Thanks for your help and reply , but unfortunately it does not work.
It needs to be a general formula that I can apply on differten spreadsheets/quality checks.
I made an example, hope you guys can help me!

 

[peterhinton]

=IF(AND(D2>(D2-C2),D2<(B2+C2)),"approved","fail")

 

[AlanY]

try this in E25 and copy down

=IF(AND(D25<=B25+C25,D25>=B25-C25),"Approved","Fail")

 

[Tetra201]

Thanks for your help and reply , but unfortunately it does not work.
It needs to be a general formula that I can apply on differten spreadsheets/quality checks.

I am really curious to hear -- in which way does not my formula work for your examples?

Have you tried adjusting references? -- Like this:
=IF(ROUND(ABS(D25-B25),6)<=C25,"Approved","Fail")

 

[Kars1995]

Yes I did tried that. But everytime I fill in the formulas I get this error.

 

[AlanY]

try this in E25 and copy down

=IF(AND(D25<=B25+C25,D25>=B25-C25),"Approved","Fail")

try this instead

=IF(AND(D25<=B25+C25,D25>=B25-C25);"Approved";"Fail")

 

[Kars1995]

try this instead

=IF(AND(D25<=B25+C25,D25>=B25-C25);"Approved";"Fail")

Sorry for the late response, but I finaly managed to have a good formula. This one works:

=IF(D27<(B27-C27);"Failed!";IF(D27>(B27+C27);"Failed!";"Approved")

Thank you everybody for your help