View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
King of Salem King of Salem is offline
external usenet poster
 
Posts: 1
Default 'plus or minus' conditional operation

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?