IF A = B (give or take 10)

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

Accepted answers

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

Just a thought....

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

Cheers,

Mark

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

Just a thought....

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

Cheers,

Mark

All Hail MarqueeCrew!!