IF A = B (give or take 10)

[JTCairns]

Hi All,

I am wondering if anyone knows a quick way in a formula to say does [Value1] = [Value2] with a tolerance of X either way?

Cheers 

[MarqueeCrew · Accepted solution]

[Value1] >= [Value2] - [Tolerance]
OR
[Value1] <= [Value2] + [Tolerance]

Just a thought....

Instead of "10" I created a variable of Tolerance.

Cheers,

Mark

[JTCairns]

All Hail MarqueeCrew!!

[Arch]

Another alternative is to use the absolute value function: ABS(A - B) <= Tolerance