if greater or less than by a value

[LunarE]

I expect this is a more logical way to achieve what I want but I cannot conceive it

The following does not work.
IF B4 is less or greater than C4 by a value of 2 or more I want to return a false.

=IF(OR(B4<(C4-2)),(B4>(C4+2)),false,true)

Thanks in advance

Lunar

 

[Michael M]

Try...you had a bracket in the wrong place

=IF(OR(B4 < C4-2,B4 > C4+2),FALSE,TRUE)

 

[Tetra201]

Try

=ABS(C4-B4)<2

 

[footoo]

=abs(b4-c4)>2

 

[LunarE]

I believe I have resolved this, the value of B4 & C4 were not formatted as numbers.

 

[LunarE]

Thanks, your solutions are elegant, I will try them both.