'plus or minus' conditional operation

[Guest]

I am trying to determine whether or not a value falls within a specification.
If A1 is -0.285, for example, and I want to say IF(ABS(A1)=0±0.5, "Pass",
"Fail") This will allow me to quickly see that if A1 is 0 plus or minus 0.5,
then it displays whether A1 passes the specification or not. Any suggestions?

 

[Dave O]

=IF(ABS(a1)<=0.5,"Pass","Fail")

....is my suggestion. But verify the "or equal to" part of the logic.

 

[Dave Peterson]

=if(abs(a1-0)<.5,"pass","fail")
or
=if(abs(a1-0)<=.5,"pass","fail")

In your case, you don't need to include the -0.
=if(abs(a1)<.5,"pass","fail")
or
=if(abs(a1)<=.5,"pass","fail")

(I don't know what happens at .5)

 

[T. Valko]

One way:

=IF(ISNUMBER(A1),IF(AND(A1>=-0.5,A1<=0.5),"Pass","Fail"),"")

 

[Bill Kuunders]

Or you simply use the conditional formatting tool.
Go to ..<Format><condional formating><cell value is>between -0.5 and
0.5..........and set the format you want.
Using font colour or pattern.

 

[Guest]

Thanks. I will try one or all of those suggestions out. I appreciate your
help.

 

[Guest]

It seems that what ended up working for me was:

=IF(AND(ABS(A1)>=0,ABS(A1)<=0.5),"Pass","Fail")

Thank you for your assistance!!

 

[David Biddulph]

What does the ABS(A1)>=0 test do?