'plus or minus' conditional operation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=IF(ABS(a1)<=0.5,"Pass","Fail")

....is my suggestion. But verify the "or equal to" part of the logic.
 
=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)
 
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.
 
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!!
 
Back
Top