View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default 'plus or minus' conditional operation

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

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