If statement ignoring values within a range

[Woofy_McWoof_Woof]

Hi, I am trying to write an If statement that ignores any value that is between -0.1 and 0.1.

For instance, in the example below the row 2 delta is 0.1 and row 3 delta is -0.1 however I want to ignore this as it is spurious. In my formula it only delivers half of the desired result and ignores the positive values, when I try and change it I then find it ignores the negative side. Any ideas how I can do it so it ignores both negative and positive between -0.1 and 0.1?

Any help would be much appreciated, thanks.

A	B	C
0.72	0.71	=if((AND(A2-B2<=0.1,A2-B2<=-0.1)),A2-B2,0)
0.86	0.85	=if((AND(A3-B3<=0.1,A3-B3<=-0.1)),A3-B3,0)

 

[aRandomHelper]

Do you mean this?

=IF(ABS(A2-B2)<=0.1,0,A2-B2)

 

[Woofy_McWoof_Woof]

Do you mean this?

=IF(ABS(A2-B2)<=0.1,0,A2-B2)

Perfect thank you